TIP: How to Find or Replace New Lines in Cells
November 16th, 2010
Using ASCII codes it is possible to find or replace invisible characters like newlines in Excel worksheet. E.g. when needed to find newlines and replace them with something else, you can use ALT+010 in the search field.
The same technique is usable for changing certain characters into new lines (inserting newlines instead of comas or semicolons e.g.).
Newlines are created in Excel while typing in the cell and pressing ALT+Enter.
