Concatenating more than 30 items

[Gus Siko]

Does anyone know how to get around the 30 item limit using the Concatenate
Function. I know that you can get around the 7 level IF Function by
referring to another cell in the last False argument, but don't know how to
concatenate 2 cells using this Concatenate function.

 

[J.E. McGimpsey]

You can use the concatenate operator.

Instead of:

=CONCATENATE(A1,A2,A3,...,A30)

use

=A1 & A2 & A3 & A4

or, perhaps more efficiently (I haven't ever checked):

=CONCATENATE(A1, A2,...,A30) & CONCATENATE(A31, A32,...,A60)