concatenate a large range.

[dcgrove]

Hello, I have a column of numbers in A1:A200 that I need to concatenate with a ";" in between each into one cell. Is there a way to do this without clicking in each cell individually? =concatenate(A1:A200) just returns the value in cell a1.

Thanks!
Clayton

[shg]

Try this:

Please Login or Register  to view this content.

=Cat(A1:A200, ";")

[dcgrove]

That worked!

Thanks!
Clayton