XL97

How can I concatenate multiple adjacent cells?

In Help it states that the Concatenate function works as
*=Concatenate(text1,text2...)* but only up to a max of 30.

Is there any way to do, for example, the equivalent of
*=Concatenate(A1:AZ1)* ?


TIA

Harry