How to replace a character in Excel with a new line

Here is the trick:

1. Select the character or string you would like to replace
2. Copy (Ctrl+C)
3. Open Find Dialog (Ctrl+F) and open Replace Tab
4. Paste the string to be repalced in the firts textbox (Ctrl+V)
5. Enter in the second textbox Alt+010 which represents a new line with its ASCII equivalent.
6. Click replace and enjoy.

No comments:

Post a Comment