Thread: How do I remove new line characters from a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I remove new line characters from a cell?
The alt-enters?

Select the range to fix
Edit|Replace
What: ctrl-j (hit and hold the control key while typing j on the keyboard)
with: (leave blank or spacebar or whatever you want)
replace all



cathyc wrote:

--

Dave Peterson
Reply With QuoteReply With Quote