VB button to create txt file from excel sheet

[I2omani]

Howdy experts,

I need your help please...Let's say that I have a list of random number J1:J5 [156,258,398,45,105]

a simple CONCATENATE formula in A6 =CONCATENATE("Number_",A2)
another simple formula in A10 =CONCATENATE(A2," Next line")

I would like to create an VB button in my excel sheet so, that when i click it, it will generate a txt file base in the info from my sheet.

txt file to be generated:
Number_156
156 Next line
blank line
Number_258
258 Next line
blank line
etc

TIA