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?