View Single Post
  #1   Report Post  
King
 
Posts: n/a
Default 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