ExcelBanter - Import Text file into multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Import Text file into multiple columns (https://www.excelbanter.com/excel-programming/280990-import-text-file-into-multiple-columns.html)

steve

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?

All times are GMT +1. The time now is 12:11 PM.