remove carriage return in multiple cells

  • Thread starter Thread starter Candy
  • Start date Start date
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
 
Andy

Select your range, then CTRL+H.

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

Click Replace All.

HTH,
Andy
 
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.
 
Back
Top