View Single Post
  #3  
Old March 27th 04, 03:14 PM
Shirley.Caylor
external usenet poster
 
Posts: n/a
Default

I'm new to the group so I didn't receive a copy of your directory but I can
tell you that importing a file into Excel is a simple procedure depending on
the type of file you have. For instance, the following is for a text file.

Import a text file
1.. Click the cell where you want to put the data from the text file.
(Usually A1)
To ensure that the external data does not replace existing data, make sure
that the worksheet has no data below or to the right of the cell you click.

2.. On the Data menu, point to Import External Data, and then click Import
Data.
3.. In the Files of type box, click Text Files.
4.. In the Look in list, locate and double-click the text file you want to
import as an external data range.
5.. To specify how you want to divide the text into columns, follow the
instructions in the Text Import Wizard, and then click Finish.
6.. In the Import Data dialog box, click Properties to set formatting and
layout options for the imported data.
7.. In the Import Data dialog box, do one of the following:
a.. To return the data to the location you selected, click Existing
worksheet, and then click OK.

b.. To return the data to a new worksheet, click New worksheet, and then
click OK. Microsoft Excel adds a new worksheet to your workbook and
automatically puts the external data range in the upper-left corner of the
new worksheet.

Hope this helps you. I'll be glad to help any way I can.

Shirley Caylor

By the way, what is a squishie? I've seen it mentioned several times and
don't know what it is.

SYC

"Queen of Squishies" hicall80 @ earthlink.net wrote in message
ink.net...
Many, many thanks from me as well, for all your excellent hard work on

this.
Much appreciated! About Excel - I too would love to have it in Excel
format, if anyone knows how to do this other than the print-it-and-type-it
option. I don't want it that bad! LOL

Karen, Queen of Squishies
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~
* We are all in the gutter, but some of us are looking at the stars. -

Oscar
Wilde *
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~
www.SimplyMusic.net
~~~~~~~~~~~~~~~




Ads