Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Insert text before end-of-cell marker in table

    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
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert text before end-of-cell marker in table

    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.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert text before end-of-cell marker in table

    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 <placeholder>^p, convert text to table, then replace <placeholder> 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 <img src=/S/duck.gif border=0 alt=duck width=23 height=23>

  4. #4
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert text before end-of-cell marker in table

    ... 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.

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert text before end-of-cell marker in table

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

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •