There are several issues with newlines in Excel. First, how do you add one as you are typing in a cell. And second, how can you use Find and Replace to add newlines?
When Typing
Simply use “Alt+Enter” to add a newline in the current cell.
Using Find and Replace
To add a newline with Find and Replace, let’s assume we have the following cell:
First, open the Find and Replace window (using Ctrl+h).
In our case, we have a semicolon between each letter. So, enter “; ” as the Find what.
In the Replace with field, press Alt. Then type 010. Then let go of the Alt key. You won’t see anything different in the field, but trust me, it is there.
Click Find Next and then Replace or just click Replace All.
Note that to see your results better, you might need to select your cells, and then click Format > Autofit Row Height.
Phlogtastic 