Thread: Remove carriage returns in an Excel document?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Remove carriage returns in an Excel document?
Highlight the cells, then do CTRL-H (Edit/Replace):

Find What: CTRL-J
Replace with: leave blank
click Replace All

Hope this helps.

Pete

On Aug 26, 9:45*pm, smartnfunnyfem
wrote:
I have an Excel document with myriad carriage returns within cells. Is there
a way to remove them all at once or do I have to manually go into each cell
and hit delete?

Reply With QuoteReply With Quote