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

This comes up when you’ve imported data from a CSV or database export and cells contain line breaks that mess up your formatting. You can’t just type a newline into the Find dialog normally — Excel needs the special key combo to recognize it.

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

Make sure you’re using the numeric keypad on the right side of your keyboard, not the number row at the top — it won’t work otherwise. On a laptop without a numpad, you may need to enable Num Lock first or use an external keyboard. You can also replace with any other character if a space doesn’t suit your needs.