remove carriage return in multiple cells

C

Candy

Hello,

I have an excel sheet with lots of data. Unfortunately lots of cells contain
carriage returns. Is there a way
to remove the carriage returns in those cells (more returns in a cell
possible)?

Thanks,

Andy
 
A

Andy Brown

Andy

Select your range, then CTRL+H.

In Find What, type 0010 (number keypad) while holding down ALT.

Click Replace All.

HTH,
Andy
 
J

Jim Rech

Try running this macro:

Sub RemoveCRLF()
Cells.Replace Chr(10), ""
Cells.Replace Chr(13), ""
End Sub

Afterward you may want to turn off Wrap Text (under Format, Cells,
Alignment) for the affected cells.
 
Top