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?