Import text file that contains rows into excel as columns

Can you upload an example of your text file?

This assumes that the lines are split by tabs - your one row is shown on 5 rows, and what comes between the entries actually matters, so you may need to post an example file.

Anyway, try code like this

Please Login or Register  to view this content.

Seems like the javascript to attach isn't working from multiple browsers. The format you see is it. Just save as a text file. If it was comma or tab, I'd be all set. Not that simple. Entries are on different lines. Thanks

Row 1:
ID: 0x5ee83 (388739)
Submission Date: 3/13/2015 11:38 AM
WebName: "mysite.co.com"
Name: "admin"
Expiration Date: 3/12/2017 11:28 AM

Row 2:
ID: 0x5ff02 (392962)
Submission Date: 3/20/2015 11:12 AM
WebName: "url.co.com"
Requester: "admin2"
Expiration Date: 3/19/2017 11:02 AM

Row 3:
ID: 0x60bba (396218)
Submission Date: 3/25/2015 2:19 PM
WebName: "mainpage.co.com"
Requester: "admin3"
Expiration Date: 3/24/2017 2:09 PM

Try it this way - slightly editied so don't use the version in your email if you got a notice:

Please Login or Register  to view this content.

Why is row Name: and rows 2 & 3 are Requester:

Row 1:
ID: 0x5ee83 (388739)
Submission Date: 3/13/2015 11:38 AM
WebName: "mysite.co.com"
Name: "admin"
Expiration Date: 3/12/2017 11:28 AM

Row 2:
ID: 0x5ff02 (392962)
Submission Date: 3/20/2015 11:12 AM
WebName: "url.co.com"
Requester: "admin2"
Expiration Date: 3/19/2017 11:02 AM

Row 3:
ID: 0x60bba (396218)
Submission Date: 3/25/2015 2:19 PM
WebName: "mainpage.co.com"
Requester: "admin3"
Certificate Expiration Date: 3/24/2017 2:09 PM

sorry those should all be requester. Trying to mask the real data before I send. That last one has Certificate too. Again it should match others. (Expiration Date)

Try this - put your labels into row 1 of the active sheet (up to but without the : ID, Submission Date, WebNam, Requester, Expiration Date) and run this:

Please Login or Register  to view this content.

Probably your row 1 values - this should flag missing headers:

Please Login or Register  to view this content.

Hello cbiz,

This macro has been tested on the data you provided in post #4. The text is placed in the correct columns "A:E" starting with row 2. Any

previous data is cleared when the macro runs.

The attached workbook has the macro added and button to run it. It will allow you to select the file to open (text only). Here is the

macro code...

Please Login or Register  to view this content.

oops - I thought the Row labels were things that you added, so try this one:

Please Login or Register  to view this content.

I wasn't expecting blank lines either. Click the button....

Just fill out row 1 with the leadins that you want to find and keep - say, it you have

New Data Point: Bernie

use

New Data Point

in, say, cell F1.

Any that you don't include in row 1 will be ignored.

The only other issue that could come up would be lines that don't have : in them. Do you have any like that?

looks like it only grabs the first row (Row 1 data). Can you try with the real sample data? All lines have a colon. Obviously between Row #s there's a blank line. Thanks

For some reason the site isn't allowing to post the code so the file attached has the code in it. Just copy the code inside the text file and paste inside your workbook.

Note: Uploaded second txt file because I see your field names have changed. look at Import txt file v2 txt.

You should have started with the real headers that you had instead of making up fake ones.

Great - thanks for letting us know that you have a solution to your issue.