Get a Quick Break in Excel


When using Text to Columns, or Find & Replace in Excel you can enter a line break by pressing CTRL + J. See how Excel finds the line breaks and moves data over to adjacent columns in the example below: