Eliminating Hard Returns from Cells

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

I currently have a column in a spreadsheet where each cell
has at least one hard return (ALT+ENTER)within the cell.
Since I have ~6,000 rows with the same issue, I was
wondering if there was a systematic way to remove all of
the hard returns in one process. Thanks for your help.
 
Select all your data and do Edit / Replace

Whilst in the 'Find What' box, hold down ALT and using the number pad on the right of your
keyboard, type 0010

Then put a space in the 'Replace with' box and hit enter.

Now just format the cells alignment to remove the wrap text feature that will be on.
 
-----Original Message-----
Select all your data and do Edit / Replace

Whilst in the 'Find What' box, hold down ALT and using
Click to expand...
the number pad on the right of your
 
Back
Top