Bernard, you just saved me HOURS of manual edits. I am actually doing the
reverse, replacing spaces with Alt-Enter. Alt+0010 did the trick. Thanks!

"Bernard Liengme" wrote:

In the Find&Replace dialog for the Find What use ALT+0010 (you must use the
numeric keypad for this)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lang Du" wrote in message
...
but if your worksheet has thousands that characters.


"SteveW" wrote:

What have you tried ?

F2, and backspace of Delete work fine for me

Steve


On Thu, 25 Jan 2007 15:56:01 -0000, Lang Du wrote:

Anyone knows how to remove Alt+Enter characters in a worksheet?

Thank you.