Thread
:
Concatenate a range
View Single Post
#
1
King
Posts: n/a
Concatenate a range
How do you concatenate an entire range at once?
=CONCATENATE(A1:A10) entered as array still only returns
the first element, A1.
There has to be something better than -
=CONCATENATE(A1,A2,A3,A4,A5,...A10)
Thanks
Reply With Quote