Remove carriage returns in an Excel document?

  • Thread starter Thread starter smartnfunnyfem
  • Start date Start date
S

smartnfunnyfem

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?
 
Highlight the cells, then do CTRL-H (Edit/Replace):

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

Hope this helps.

Pete
 
Bless you!

Pete_UK said:
Highlight the cells, then do CTRL-H (Edit/Replace):

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

Hope this helps.

Pete
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carriage return displays as a small box 8
Unicode text and carriage returns 4
copying/pasting accurately from a Word table (carriage returns) 1
Getting rid of carriage return in cell 4
Delete Carriage Returns 4
how do i format carriage returns for each cell in excel? 1
Replacing carriage returns with a comma 4
carriage returns 2

Back
Top