Posted to microsoft.public.excel.worksheet.functions
|
|
Concatenation
See
http://www.mcgimpsey.com/excel/udfs/multicat.html
In article ,
"Harry" wrote:
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
|