MS Excel - Concat with a delimiter

Question

I've got a long spreadsheet with numbers.

I need to get them in one string delimited by ; eg. 4364453;24332432;2342432

I know I can do:

=concat(A1:A2000)

but that will merge it in one string without the delimiter - I can't seem to find an option for a delimiter when you specify a range.

Answer 1

Use TEXTJOIN() instead:

=TEXTJOIN(";",TRUE,A1:A2000)

I hope this helps you.