Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Excel: how do I remove all carriage returns from a cell?

Tags:

I want to get rid of all the carriage returns in my cell. How do I do this?

like image 777
Alex Gordon Avatar asked Oct 05 '10 00:10

Alex Gordon


People also ask

How do I remove carriage breaks in Excel?

Place the cursor in the 'Find what' field and use the keyboard shortcut – Control + J (hold the Control key and press the J key). You may not see anything, but this puts the line break character in the 'Find what' field. In the replace field, enter a comma followed by a space character (, ) Click on Replace All.

Which formula would replace all carriage returns in a cell with the pipe symbol?

Changing =SUBSTITUTE(A1,CHAR(10),"") to =SUBSTITUTE(A1,CHAR(10)," ") will replace all carriage returns with a space.


1 Answers

=CLEAN(A1)

Clean removes all nonprintable characters from text. -- Excel Help Documentation

like image 137
Nick Spreitzer Avatar answered Oct 01 '22 04:10

Nick Spreitzer