If you look really close, you may see a little bit of the pixels--but the text
is wrapping in the replace dialog, too. (I can't see what's there, but I do see
just a bit of it.)

wennerberg wrote:

Thanks for the direction on this! It works well, but here is one
caveat:
If you replace a "real" character along with the ctl+j, the "real"
character does not display in the dialog box:

ORIGINAL STRING:
Washington D.C. (North)

CHANGE TO:
Washington D.C.
(North)

To do this I must include the left parenthesis because of multiple
spaces in the string, and therefore search for "<space(" and replace
with "ctl+j("

The parenthesis do not show up in the Find and Replace dialog box in
"Replace with:" after entering the ctl+j or alt+0010 on num pad, but it
does keep the parenthesis. I just use my imagination.

--
wennerberg
------------------------------------------------------------------------
wennerberg's Profile: http://www.excelforum.com/member.php...fo&userid=7321
View this thread: http://www.excelforum.com/showthread...hreadid=471253

--

Dave Peterson