View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 141
Default Import Text file into multiple columns

I have a text file that has the following:

Name: steve
Address: 6416
State: MO

I want to import to Xcel and have it look like:
Name Address State
Steve 6416 Mo
Jack 2222 MO

How can I do this?