Concatenate a Column into one cell with a , between values

[Oceans]

I have column F, populated with specific data:
a071717 - Hailtrox, Ed
a071717 - Hailtrox, Ed
- GVZ_GDR XYZ Helpdesk – Security Data
a473349 - Zvivt, Xiaotonk
a464784 - Mxlaahan, Michael
a058079 - Charles, Gerri


I need to extract and concatenate Only the "A number" (ex: a058079) into one cell separated by a ,
so i can copy and paste into a SQL query.

currently the F column starts at F10 ends at F14470

[Jakobshavn]

This macro assumes that the data follows your example:

Please Login or Register  to view this content.

[Oceans]

Thanks, but what are the steps to run / execute this macro ?
I clicked Alt F11, the paste it into new module, then saved the file as Macro Enabled, then what ?

This macro assumes that the data follows your example:

Please Login or Register  to view this content.

[Oceans]

Actually, I think I got it. Now another problem, it did work well, and extracted all data perfectly. But for the Query, the string is more than 4000 characters !
So how can i get to execute the macro in portions of that column ?

Thanks, but what are the steps to run / execute this macro ?
I clicked Alt F11, the paste it into new module, then saved the file as Macro Enabled, then what ?

[Oceans]

You might think i am funny.

But i think i got my second question as well.

For i = 10 To 14470 <<<< here is where i can control the amount of data.....................Right?

Actually, I think I got it. Now another problem, it did work well, and extracted all data perfectly. But for the Query, the string is more than 4000 characters !
So how can i get to execute the macro in portions of that column ?

[Jakobshavn]

Just change the 10 and the 14470