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)

By Andrew Odendaal, ago