Concatenate Query (with a twist)

[Dave350z]

Hi all,
I have a long list of customer ID's that I need to upload to another system, the problem is, to do this is a manual exercise as the each customer ID is put into a single field in the other system and separated by a semi colon.

In the sample, I've just listed out a few customer id's, but I'm trying to come up with something that would concatenate each into a single cell and separate them by a semi colon.

Any ideas, guidance is always appreciated!

Thanks in advance!

Dave

[Glenn Kennedy]

So - should the output be all the IDs in 1 cell, separated by ; or what??

[Dave350z]

Yes, all in one cell and separated by ;

[Glenn Kennedy]

Try this out.....

http://www.get-digital-help.com/2011...-vba-in-excel/

[Dave350z]

That'll do nicely!! Thanks!!

[Glenn Kennedy]

You're very welcome and thanks for the Reputation.