Concatenate cells or ranges based on conditions

Im not sure what you call what i want to do, if anyone can let me know. Its a simple thing, that its slipped my mind at the moment.

Right, Im happy to use VBA as well as the good ol' formulas.

Here it is.

I have a list of people to send drawings out to.
I have already made the selections am just trying to work out how to simplify the output so as to use as a field in a data file to go onto a letter.

eg.
"| A01 | A02 | A03 | A04 | A05 | A06 | A07 |" are for Joe Bloggs
( | are cells)

In another cell, i would like to merge them together like so

"A01-A07" are for Joe Bloggs

And also as follows

"| A01 | | A03 | A04 | A05 | | A07 |" are for John Smith

would like this to be
"A01, A03-A05,A07" are for John Smith.

So differing conditions depending on what happens in the range.
I have had a couple of attempts at this using a VBA concatenate command, I can get them to display like "A01,A02,A03..." with a selected separator, but cannot get it how i want it.

If it does involves a lot of coding, never mind, i will leave it out.

Thank you in advance

please read the forum rules and amend your thread title. you're asking how to concatenate cells or ranges based on conditions, so there's your title.

also, it would help to see a workbook with a data sample that illustrates your layout, data input, processing logic, data output.

cheers

Not very elegant and I'm sure it could be vastly improved but based upon your sample file perhaps:

Please Login or Register  to view this content.

Called from cell

Please Login or Register  to view this content.