Text to Columns on Line Breaks

Text to Columns on Line Breaks

July 20, 2019

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. 

 

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com