Remove carriage returns in an Excel document?
 

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?

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?

Remove carriage returns in an Excel document?
 

Bless you!

"Pete_UK" wrote:

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?

Remove carriage returns in an Excel document?
 

You're welcome - should have saved you a bit of time !! <bg

Pete

On Aug 26, 10:00*pm, smartnfunnyfem
wrote:
Bless you!