MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing text files into Excel

Posted by Mark Breibart on August 06, 2001 6:21 AM

When importing a tab-delimited text file, some of the
fields are things like zip codes, which I want Excel
to treat as character strings even though they are all
numeric. The Import Text Wizard can change the
type of the field from "General" to "Text". But the
import file is quite wide, with lots of similar fields
and I don't want users to have to manually reset the
field types every time.
Is there a way, without a macro, to imbed something
in the import file to force Excel to treat the field
as "text"? (When entering data interactively
into Excel, the single quote (" ' ") tells Excel the
field is "text". Anything similar on import?)

Posted by lenze on August 06, 2001 2:40 PM

On the Third panel of the Import Wizard, Select the columns you want to be text and then choose the Text option button