Would there ever be a reaosn why you would use the CONCATENATE formula [=CONCATENATE(A1,B1)] if you can just use the Ampersand method [=A1&B1]?
AKA, does the ampersand method make CONCATENATE obsolete, or would there ever be a time when the ampersand wouldn't suffice and CONCATENATE would be necessary?
thank you!)
There is no difference between the two that I am aware of, so it's simply a matter of personal preference.
Hi xtinct2,
I do remember a point about VBA and the ampersand. In VBA "&" immediately after a variable name is a Type Declaration symbol. I've seen errors in running code because a space is needed between a variable and the ampersand.
Read:
http://www.j-walk.com/ss/excel/faqs/xl97faq3.htm
There are some old Excel versions that also had problems with concatination of Strings and non-integer variables, in that a type mismatch error would occur. I believe these have been fixed in newer versions of excel.
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks