Convert Tab Separated File to Excel Columns

4
47




About this tutorial:

Video duration: 12:49
This video shows how to covert a text file that is delimited by tabs to a excel file with the values separated into columns. Two examples will be shown: (1) A simple file is imported with the Text Import Wizard (2) A more complex example where you may have tab delimited text files import in a recurring basis (weekly/daily). This second example uses the Power Query feature.

P.S. Feel free to provide a comment or share it with a friend! ————————————————————————————————-

Subscribe to the Blog: http://myexcelcharts.blogspot.com

4 COMMENTS

LEAVE A REPLY