Straighten Me Out Please

[Phillip Crum]

I want to import a .txt file into a preformatted Excel spreadsheet. Is it
possible to do that and 'map' the data transfer in advance so that
information goes where it's supposed to go in the spreadsheet? If so,
what's this little operation called and where do I begin my learning
curve? :-(

 

[CLR]

Hi Phillip.........

I do this regularly, and the way I do it is quite an involved process,
really beyond exact instructions in this forum...........but briefly, I copy
and paste the text file into column A in my sheet, then find key words and
break them out into a helper column inserted before A, then do Data > Text
to columns to expand the text, then block out RANGES based on my keywords,
then INDEX in those keyword ranges to find the cells of
interest...........like I said, kind of the long way around, but the only
way I know, and it does work.............

hth
Vaya con Dios,
Chuck, CABGx3


I want to import a .txt file into a preformatted Excel spreadsheet. Is it
possible to do that and 'map' the data transfer in advance so that
information goes where it's supposed to go in the spreadsheet? If so,
what's this little operation called and where do I begin my learning
curve? :-(

 

[Myrna Larson]

There's no way to do an automatic import and have the data imported in any
order except the order that's found in the text file, i.e. you can't move the
columns around at this point. You would have to do that later.

 

[Dana DeLouis]

Sometimes this will work for me. Select the upper left corner of your
"Template" area on your sheet. (not necessarily A1).
Then, Data | Import External Data | Import Data...
I like this sometimes over File | Open.
But it depends.. If you have to move columns around, it may be better to
open on a clean sheet first.
HTH
--
Dana DeLouis
Win XP & Office 2003


I want to import a .txt file into a preformatted Excel spreadsheet. Is it
possible to do that and 'map' the data transfer in advance so that
information goes where it's supposed to go in the spreadsheet? If so,
what's this little operation called and where do I begin my learning
curve? :-(