View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How to remove Alt+Enter character in a worksheet?

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.