- In Word replace all the paragraph marks with a unique character.
- In Excel replace the unique character with the Excel line break character.
- In the Replace field, enter the following Alt code: Alt+0010. This code enters in a single line break. You will not see this character but the cursor may change.
Note, to enter an Alt code, hold down the Alt key as you type the digits on the numeric keypad. It may help to have Num Lock on.