Concatenate a range of numbers in one column

This should be easy but I am struggling. I need to concatenate a selected range of cells (which are all numbers) in one column and, follow each number with a semicolon and space. This is something I will do repeatedly using different cells in that same coolum. Thanks.

Using a UDF

Please Login or Register  to view this content.

and used like
=ConcatJoin(A9:A25)

Thanks so much. I am getting a Name error when I try to run. I copied and pasted in as a module and saved it. Then went to cell in workbook and typed =ConcatJoin(A2:A9)

Did you put the code in a regular module (eg Module1), or did you put it in a sheet module or the Thisworkbook module?

Nevermind - figured out MY problem. ALll is good. Thanks again!

You're welcome & thanks for the feedback