Kamis, Agustus 18, 2011

Excel : Delete new line

Case : You have a text :

I want
to
eat

in column A1, and  you want to replace into single line : I want to eat.
This kind of thing gonna be a troublesome if you have 1000 lines to change.
Instead of replacing manual one by one, you can do this trick :

1. Press Ctrl + F
2. Switch to "Replace" tab
3. Put active cursor into "Find what" column
4. Press Alt + 010
5. Press "Replace All" button

Now all new lines will be delete.

Source : http://www.excelforum.com/excel-general/670112-deleting-new-line-character.html

0 comments: