Concatenate

  • Thread starter Thread starter Paul Black
  • Start date Start date
P

Paul Black

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
 
Hi Again,

Has Anybody got Any Comments One Way Or Another on this Please.

All the Best.
Paul
 
I don't know if there's a calculation time difference, but I like the
=a1&b1&c1
version.

It's less typing and it doesn't use a function.

So I don't need to have to worry about exceeding the limit of 7 nested functions
limit.
 
Hi Paul,

Like Dave, I use the second (non Concatenate) form.

FWIW, in limited testing, running each through series of 10^6 loops, the
Concatenate method appeared to be aproximately 30% slower.
 
Thanks for the Replies Dave & Norman,

I was Just Curious as my Spreadsheet Seems to take a Long time to
Calculate. Although as I said, my Spreadsheet does have Many Sheets and
Quite a Few Thousand Concatenate Formulas. It is also about 45 Meg in
Size. I Personally do like the Format of Using "Concatenate" as it
Makes it Easier to Read for me. I will try Changing a Couple of Sheets
to the "&" Format and see if there is an Increase in Calculation Speed.

Thankyou Both Again.
All the Best.
Paul
 
Back
Top