top of page

Text to Columns on Line Breaks

Nearly all Excel users will have been burned using the Text to Columns tool in Excel when trying to parse out data in an Excel column that has line breaks. Excel will cut off the text after the line break. If you want to split data in a column where the line break appears, after choosing the option for delimited text, in the Other box enter, ALT + 0010 (on the number keypad). This will allow Excel to separate the text after the line break into a new column.

bottom of page