import text data into existing spreadsheet

[Mark J]

I would like to import a line of data in into an existing excel
spreadsheet. I have an online form that delivers a first name, last
name, address info, email and phone number in a comma delimited
format.

I can save this from my email program in a plain text format.

Then I want to import this text into an existing spreadsheet with the
fields already laid out in columns. As I get more people who sign up,
by importing the data, the list will get longer.

I can see how to import the data into the spreadsheet once, and this
works fine. But I want to do this in an additive way, one line at at
time.

How can I do this?

 

[Tom Ogilvy]

What version of Excel?

if excel 2000 or later look at

Data=>Get External Data => Import Text file

If Get External Data doesn't appear on the Data menu, you need to install MS
Query using office install.

Regards,
Tom Ogilvy

 

[Mark J]

Tom,

Thanks, this is exactly what I wanted, and works perfectly.

mark