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:
Posting Komentar