Sunday, May 26, 2013

How to Import Delimited ASCII127 in Excel


1. Run the Excel 2010 application.
2. Click the 'File' tab and click 'Open' to open a file browser window. Click the 'Files' drop-down list, and choose 'Text Files.'
3. Navigate the file browser to the delimited ASCII TXT file that you wish to import, then click 'Open.' Excel will initiate the Import Text Wizard.
4. Click the radio button next to 'Delimited,' and click the 'Next' button.
5. Click the radio button next to the character that the ASCII file uses for delimiting fields. If your delimiting character is not in the list, then click 'Other,' and type the character into the adjacent field.
6. Click 'Next' and 'OK' to complete the Text Import Wizard. Excel will import data from your delimited ASCII text file and will automatically assign cell formatting that it deems appropriate for the type of value that is contained in each field.

Blogger news