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



Paul Black wrote:
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 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.


---
Regards,
Norman



"Paul Black" wrote in message
oups.com...
Hi Again,

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

All the Best.
Paul



Paul Black wrote:
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

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

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.

Paul Black wrote:

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

--

Dave Peterson