how do I enable "import text file" excel 2002?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When importing text files into an Excel worksheet I previously went to
"data" > "import external data" > "import text file"

With Excel 2002 my choices lead me to a"select data source" window which is
much more cumbersome. Does the "import text file" still exist in excel 2002?
 
I pretty much use:
file|open
and copy that imported data to where I want it.

But you can add an icon to your favorite toolbar to skip a step or two.
tools|customize|commands tab|Data category
look for "import data" and drag it to where you want.

(not much help, though.)
 
It was really helpful to learn that the "customize" feature in the "tools"
command would give me a solution to my problem. Now that I know about
it , I'll use it more often.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where is the Data Import Excel button in Excel 2007 6
Import more than one .csv file into the same Excel file. 1
text file contains more data than will fit for a single worksheet 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Importing text with text qualifier 2
IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES 4
Import text file to a SINGLE ROW? 1
Importing Text Files Into Access 1

Back
Top