Hi all. I'm new to the forum today, and I have already found the extremely helpful macro for creating individual text files from multiple rows in excel where col A becomes the file name.

I now want to go a bit further, by creating a text file with multiple rows from a single row in excel.

For example, I have a row in excel that reads:
A B C D E F G
list1 address1 41 beech avenue address2 35 grove avenue address3 99 oak road


and I want to create a text file named "list1" where the contents are set out as:
address1 41 beech avenue
address2 35 grove avenue
address3 99 oak road

Can anyone help me on this please?

Many thanks,

cagey1953