MS Excel Secrets - Importing a Text File in Excel 2007
http://ingenuitydias.blogspot.com/2014/03/ms-excel-secrets-importing-text-file-in.html
Importing a text file in Excel 2007:
1. Select File -> Open -> find the text file and click Open.
2. In Text Import Wizard dialogue box:
Step 1:
Select Delimited, US- ASCII and click Next.
Step 3:
For each column select the Column Data Format and click Finish.
1. Select File -> Open -> find the text file and click Open.
2. In Text Import Wizard dialogue box:
Step 1:
Select Delimited, US- ASCII and click Next.
Step 3:
For each column select the Column Data Format and click Finish.