SOLVED Import list from txt to excel

**markmash** · 04-22-2010, 10:30 AM

Hi,

I need to import a mailing list from a txt file to excel. This I can do but I need it to stay in column A and go down the rows as oppose to along the columns?

I feel this is really easy but I cant do it.

Any help much appreciated,

Thanks

Mark

**martindwilson** · 04-22-2010, 11:14 AM

what seperates the fields?

**markmash** · 04-22-2010, 11:53 AM

Tks martin, its a comma which separates the field

**martindwilson** · 04-22-2010, 11:58 AM

one way
open with word
find replace all comma with ^p save as text then import into excel

**markmash** · 04-22-2010, 03:14 PM

Thanks Martin,

Ill try that.

Any other suggestions?

Best

Mark

**markmash** · 04-23-2010, 05:17 AM

Actually that worked great,

Thanks again Martin

SOLVED Import list from txt to excel

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

SOLVED Import list from txt to excel

Re: I need to import list from txt to excel

Re: Import list from txt to excel

Re: Import list from txt to excel

Re: Import list from txt to excel

Re: Import list from txt to excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions