View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to remove Alt+Enter character in a worksheet?

Select your range to fix
Edit|Replace
what: ctrl-j (it may not look like anything in that box, but try it)
with: (leave blank -- or a space character??????)
replace all

Lang Du wrote:

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

Thank you.


--

Dave Peterson