A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to make end of cell character part of find...replace



 
 
Thread Tools Display Modes
  #1  
Old March 17th 19, 05:12 AM
Styler001 Styler001 is offline
Junior Member
 
First recorded activity by WordBanter: Mar 2019
Posts: 1
Default How to make end of cell character part of find...replace

This is going to be hard to visualize without the actual mocked-up table I'm working with, but I'll give it a shot. You may recognize this as being quotes from "A Tale of Two Cities". I couldn't use the actual text in this example, since it's work-related.

I've got a table that I need to do a find...replace. I'll try to show it here. Each lined-off section is a cell in a table.

---------------------------------------------------------------------------------
• It was the year of Our Lord one thousand seven hundred and seventy-five.€
---------------------------------------------------------------------------------
• Spiritual revelations were conceded to England at that favoured period, as at this.€
---------------------------------------------------------------------------------
• Wo-ho! said the coachman.€
---------------------------------------------------------------------------------
• What o'clock do you make it, Joe?
• Ten minutes, good, past eleven.
• €
---------------------------------------------------------------------------------
• What do you say, Tom?€
---------------------------------------------------------------------------------
• They both listened.€
---------------------------------------------------------------------------------
• I say a horse at a canter coming up, Joe.
• I say a horse at a gallop, Tom.€
---------------------------------------------------------------------------------
• Is that the Dover mail?
•
• €
---------------------------------------------------------------------------------
• Why do you want to know?€
---------------------------------------------------------------------------------
• I want a passenger, if it is.€
---------------------------------------------------------------------------------

As you can see, each cell ends with a € character when viewing the formatting in the document, but I haven't been able to figure out a way to include that as part of the find.

I can easily enough do a find...replace where "^l• ^l• " is replaced with nothing when there are two "blank" lines (lines with just the • and a space "• ". But, when there is only one blank line, as in cell 4, if I try to replace "^l• ", cell 7 then turns into "• I say a horse at a canter coming up, Joe.I say a horse at a gallop, Tom." with what should be two lines but are now crammed together.

Here's what I would expect as the final result if I could figure out how to replace things like I want.

---------------------------------------------------------------------------------
• It was the year of Our Lord one thousand seven hundred and seventy-five.€
---------------------------------------------------------------------------------
• Spiritual revelations were conceded to England at that favoured period, as at this.€
---------------------------------------------------------------------------------
• Wo-ho! said the coachman.€
---------------------------------------------------------------------------------
• What o'clock do you make it, Joe?
• Ten minutes, good, past eleven.€
---------------------------------------------------------------------------------
• What do you say, Tom?€
---------------------------------------------------------------------------------
• They both listened.€
---------------------------------------------------------------------------------
• I say a horse at a canter coming up, Joe.
• I say a horse at a gallop, Tom.€
---------------------------------------------------------------------------------
• Is that the Dover mail?€
---------------------------------------------------------------------------------
• Why do you want to know?€
---------------------------------------------------------------------------------
• I want a passenger, if it is.€
---------------------------------------------------------------------------------

If anyone can help with this, I'd greatly appreciate it.
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Character Karen Microsoft Word Help 2 May 13th 09 06:23 PM
Find&Replace character before end-of-cell mark [email protected] Tables 6 November 27th 08 07:12 AM
Find and replace a character [email protected] Microsoft Word Help 1 September 27th 07 11:39 AM
How to do a find and replace on part of a document? Thomas FG Gilbert Microsoft Word Help 2 March 23rd 07 07:05 AM
Find/Replace specific character michaelberrier Microsoft Word Help 3 January 24th 07 07:26 AM


All times are GMT +1. The time now is 07:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.