Concatenate
 

I need to concatenate about 100 cells.

The concatenate function only accepts 25 cells.

Is there any way to concatenate all the cells in a simple formula?

try
= concatinate(GROUP1) &concatinate(GROUP2)&concatinate(Group3) &
concatinate(Group4)

"Jeff" wrote:

I need to concatenate about 100 cells.

The concatenate function only accepts 25 cells.

Is there any way to concatenate all the cells in a simple formula?

Jeff -

Try using the & function. I test it out to 38 and it was still going.
eg. =a1&a2&a3.....

Hope this works for you.

"Jeff" wrote:

I need to concatenate about 100 cells.

The concatenate function only accepts 25 cells.

Is there any way to concatenate all the cells in a simple formula?

Do you mind a UDF? This will work:

Function ConCat(rng As Range)
Dim temp As String
For Each rng In rng
temp = temp & rng
Next
ConCat = temp
End Function

Then, all you have to do to call it is input as a range like so:

=ConCat(A1:A1000)


--
Regards,
Dave


"Jeff" wrote:

I need to concatenate about 100 cells.

The concatenate function only accepts 25 cells.

Is there any way to concatenate all the cells in a simple formula?

Hi Jeff

Try
=Your_formula&another_concatenate_formula&another_ concatenate_formula&another_concatenate_formula


Regards

Roger Govier



Jeff wrote:

I need to concatenate about 100 cells.

The concatenate function only accepts 25 cells.

Is there any way to concatenate all the cells in a simple formula?