Import Text file into multiple columns

S

Steve

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?
 
Top