Remove carriage returns in an Excel document?

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?
 
P

Pete_UK

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

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

Hope this helps.

Pete
 
S

smartnfunnyfem

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
how do i format carriage returns for each cell in excel? 1
Delete Carriage Returns 4
Getting rid of carriage return in cell 4
Replacing carriage returns with a comma 4
carriage returns 5

Top