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)
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)