Save rows as text file & name file from a cell

**nebraska** · 04-01-2011, 11:19 AM

I am new here. I have seen similar questions asked here, but nothing exactly like this. Thank you for your consideration in answering this question.

I have a rather large Excel file with two columns. Column 'A' has a number code, "1234567" for example. Column 'B' has a description, "H3WW8Y Widget Steel" for example.

I want to export all of the column 'B' rows as separate text files and name them after column 'A'. So after the code is run (or formula), there would be a file called "1234567.txt". That "1234567.txt" file would contain "H3WW8Y Widget Steel".

A______ B
1 1234567 H3WW8Y Widget Steel
2 1234568 A3WW8A Widget Steel
3 1234569 B3WW8B Widget Steel
4 1234570 C3WW8C Widget Steel

Any assistance is appreciated! Thank you!

**MarvinP** · 04-01-2011, 11:54 AM

Hi nebraska,

I rarely say this, but it seems you are going to make your problem harder by splitting your data into separate text files. There must be a better way.

If you could, please explain what the problem is and what you are trying to accomplish.

I'm pretty sure we can help make this problem easier without needing to split your Excel data into a bunch of txt files.

**nimrod** · 04-01-2011, 12:08 PM

Please Login or Register  to view this content.

**nebraska** · 04-01-2011, 05:31 PM

Absolutely perfect Nimrod! Thank you!

**nebraska** · 04-01-2011, 05:36 PM

Thank you for even looking at my problem MarvinP. Unfortunately my server is setup to expect an additional .txt file for extended descriptions. It was either ask this question or modify a perl parser. I chose this one because it was quicker.