Convert txt file

[Jim6652]

How can I convert a txt, comma delimited file to Excel spreadsheet format with rows of text separated in appropriate columns?

 

[Tazguy37]

Use File, Open, and Text files in the Files of Type: selection box. That should take you through the Text Import Wizard. Hope that helps!

 

[Jim6652]

Taz,

Simple enough. That worked. Thanks!

 

[timwangTM]

Another good way: Data > Get External Data > Import Text File ...also come out Text Import Wizard. But the benefit is that you can refresh the data into your Excel at any time when the data (same format) changed in text file by click menu Tools > Refresh.