Concatenate

J

Jeff

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?
 
B

bj

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

Matt Cromer

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

David Billigmeier

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)
 
R

Roger Govier

Hi Jeff

Try
=Your_formula&another_concatenate_formula&another_concatenate_formula&another_concatenate_formula


Regards

Roger Govier
 
Top