Thread: Concatenate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Concatenate

Hi Everyone,

I have a Workbook that Contains About 50 Worksheets.
Within those 50 Worksheets I have in the Region of 10,000 Formulas that
Contain the Concatenate Function.
Is it Better for Example to Use a Formula Like ...
=Concatenate(A1,B1,C1,D1,E1,F1)
OR ...
=A1&B1&C1&D1&E1&F1
The First One is Obviously Easier to Interpret, But is there a Price to
Pay with Regard to Calculation Time for Example.

Thanks in Advance.
All the Best.
Paul