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)

In article <39fqb.70675$(E-Mail Removed)>,
"Gus Siko" <(E-Mail Removed)> wrote:

> 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.
>
>