I know you can insert a line break in an excel cell by using alt+enter, but can I replace text with a line break using the replace tool??

5/8/2007 5:05:18 PM

Edit>Replace.

Find what: text
Replace with: Alt+0010

hold Alt and hit 0010 on the numpad then release Alt

5/8/2007 5:53:38 PM

I owe you a beer.

5/8/2007 5:56:45 PM