Concatenating more than 30 items

  • Thread starter Thread starter Gus Siko
  • Start date Start date
G

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.
 
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)
 
Back
Top