Concatenate

[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

 

[Paul Black]

Hi Again,

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

All the Best.
Paul

 

[Dave Peterson]

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.

 

[Norman Jones]

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.

 

[Paul Black]

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