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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows to columns with multiple sets 1
Merging from an Excel file with graphics 1
Help!! Extracting data from a single field 2
Excel 2007: Weird Pivot Table Sorting Problem 1
need to import a svg file into publisher 3
Text duplication question 0
Search for "text" in description - if certain text - display "text" in another row 9
Finding the nearest match without reusing results 15

Top