How Can I: Improve/Condense this CONCATONATE-STYLE formula?

[Sandcastle]

I hope that title is not out of line - I don't know how else to phrase the objective.

Here's what's up:

1. I have a list of cells that contain ID numbers.
2. I need to insert that list into a paragraph with a comma between each.
3. Sometimes there will be blanks in the list

This is the final output:
"Please list the following application numbers on the invoice: 101101, 102102, 103103, 104104, 105105, 106106, 107107, 108108, 109109."

This is the giant formula that I've mustered:

Please Login or Register  to view this content.

I feel like there's a better way, haha

[lecxe]

Hi

There is no native function to concatenate a range. You either write your own function or you use the concatenate function or operation, like you did.

Using just the concatenation operator you can, however, make the formula smaller. If the cells have only 1 number or nothing, like in the example, try:

Please Login or Register  to view this content.

[lecxe]

delete this

[lecxe]

delete this

[Sandcastle]

Excellent! Thank you for that. I don't understand it fully, but it works

[lecxe]

You're welcome. Thanks for the feedback.