Insert text before end-of-cell marker in table

Topic

New Reply

I have a table of names and addresses, and wish to insert some text in each cell immediately before the end-of cell marker, using Find/Replace.

So effectively, I want to change the end-of-cell marker which shows as

Reply | Quote

Replies

According to Klaus Linke, the end of cell marker and end of row marker cannot be found using Find/Replace. It is possible using VBA, but you didn’t want to hear that…

See this newsgroup thread if you’re interested.

Reply | Quote

Thanks, everyone — I will try assorted variants of your suggestions!

John

Reply | Quote

Is it feasible to convert the table to text and then use find/replace to insert a placeholder? If, for example, the text you wish to add is in the last cell in each row then you could convert to text (separate cells with tabs, say) then do a mass replace of ^p with ^p, convert text to table, then replace with ^p^tUK and Robert is your mother’s brother.

Things get slightly more complex if there are already paragraph marks in the cells as you would need to convert those to something else (i.e. another placeholder) before zapping the table to text and then, of course, change them back as the last step. Without knowing the form of the names and addresses it is hard to tell whether this is a possibility. And if your table has had hours of aesthetically-pleasing formatting applied then you probably don’t want to destroy that at the stroke of a mouse!!

And , of course, depending on the complexity of the table the convolutions that you have to go through with find/replace may make programming a macro look positively attractive

Reply | Quote

… and then there is the ‘record a macro’ method (the stuff below is from memory – so adapt as required)

Position in the first cell
Turn on Macro record and assign to a key combination,
Press {Tab} to get to last cell
Press {Right}{Left} to get to last character in cell
Type your text
Press {Tab} to position in first cell of next row.
Stop Macro recording

and run it a lot of times by pressing your key combination
Dirty – but it often works better than more complex methods.

Reply | Quote