Output selection to a single string

[estimablesir]

Hello,

I'm completely new to VBA for excel and would greatly appreciate some guidance. The problem, is that I have a single column containing a list of IDs like this:

002234
000023
022212
023232
021232

My goal, is to format these IDs such that they are concatenated into a single string, with each ID separated by a semicolon. More importantly, I need to output the results to a text file. So the resulting text file would look like this:

002234;000023;022212;023232;021232

Would anyone be able to assist me?

[dominicb]

Good morning estimablesir

...and welcome to the forum!!

My goal, is to format these IDs such that they are concatenated into a single string, with each ID separated by a semicolon. More importantly, I need to output the results to a text file.

This code should do the trick. Amend the path as shown, select the range you want exporting to a textfile and run the macro.

Please Login or Register  to view this content.

HTH

DominicB

[estimablesir]

Worked like a charm, thanks very much!

[cc9083]

Sorry. Need to bump here. How do I tweak it if my data is in rows and not column. I would like the string to be at the end of row.

[shg]

Please take a few minutes to read the forum rules, and then start your own thread.

[cc9083]

Sorry. Will create a new one now.