Find and Replace Line Breaks in Excel
http://www.contextures.com/xlDataEntr... Visit this page for more Excel data entry tips.
To create a line break in a cell, you press Alt + Enter. Later, if you want to replace all the line breaks with a space character, you can use a special shortcut in the Find and Replace dialog box.
Watch this short video to see the steps.
TROUBLESHOOTING:
If you try to find line breaks a second time, Excel might say it can't find any.
Try these steps to fix the problem:
1) Press Ctrl+H to open Find and Replace
2) Click on the Replace tab -- you'll see a light border around the word
3) Press the Tab key -- that selects everything in the Find What box (there might still be an entry hidden there, from a previous search)
4) Type Ctrl+J -- that replaces anything in the Find What box