Hi All,

I have data in column A, I need a macro that creates .txt files with data present in each cell A and repeat the process till the end of file.

e.g My Sheet :

A1 = ABC
A2 = BG2

Expected Out

Files ABC.txt and BG2.txt should be created.

Kindly do the needful.