Replace Newline Break in Excel


Ever needed to find & replace the newline character in a large excel document?

In the Replace Dialog (Ctrl+F)
Find: Hold down [alt] and type 010 on the numeric keypad.
Replace: Replace with a space " " (without quotes)