Help w/ Advanced Find and Replace

[VirtuAllin]

Hello all - I need your expertise.

I have an Excel file with a couple of columns that I'd like to do a
'Find and Replace' on - where the find text is "***sig***" and the
replace text is a multi-line email signature such as:

Joe Smith
ABC Realty Company
(555) 555-1212

Of course, the normal find/replace function in Excel doesn't recognize
multi-lines of data.

I tried to use the normal function - I input the find string then
pasted a one-line version of the signature and then hit 'Alt 010' for
each new line started from the end (you can't see more than the top
line) and then hit 'replace all' but Excel replaced the entire
contents rather than just the ***sig*** find text string. Ugh - and
even if it worked, it seems a sloppy and time consuming method.

Any hints? Thanks in advance for your help!

Cheryl

 

[Dave Peterson]

It worked ok when I used alt-0010 (using the keys on the number keypad).

But even easier is if I used ctrl-j instead. The "to" textbox was difficult to
read (it doesn't expand), but it does work (both ways).

And be careful.

If your text is really ***sig***, you'll want to make sure those asterisks are
not treated as wildcards.

The from string will be:
~*~*~*sig~*~*~*