=CONCATENATE

Chris Davison · Apr 4th, 2002, 12:17 PM

is =CONCATENATE an old function or something ?

=CONCATENATE(A1,B1) seems to be much more tiresome than =A1&B1

or maybe there's some subtelties behind each ?

IML · Apr 4th, 2002, 12:20 PM

It is just short hand, as + is to the SUM function. Otherwise they behave identically.

Mark W. · Apr 4th, 2002, 01:00 PM

Sometimes it's easier to formulate. The argument list for...

=CONCATENATE(F8,G14,E18,E9,D2,G4,I9,I17,H28,C21,B13,A8,C14,D5)

...can be completed with 14 Control+(Mouse)Clicks.

Not, that I would recommend such a formula!!!

Chris Davison · Apr 4th, 2002, 01:41 PM

thanks IML, thanks Mark

just so long as there's no underlying subtelties between the two methods

I prefer the "&" method, although have found that clicking the relevant cell with my mouse between "&"s causes much stress on my left hand trying to hold down "shift" and "7"

cheers guys

Apr 4th, 2002, 12:17 PM	#1
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	is =CONCATENATE an old function or something ? =CONCATENATE(A1,B1) seems to be much more tiresome than =A1&B1 or maybe there's some subtelties behind each ? __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 12:20 PM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	It is just short hand, as + is to the SUM function. Otherwise they behave identically.

Apr 4th, 2002, 01:00 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Sometimes it's easier to formulate. The argument list for... =CONCATENATE(F8,G14,E18,E9,D2,G4,I9,I17,H28,C21,B13,A8,C14,D5) ...can be completed with 14 Control+(Mouse)Clicks. Not, that I would recommend such a formula!!!

Apr 4th, 2002, 01:41 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	thanks IML, thanks Mark just so long as there's no underlying subtelties between the two methods I prefer the "&" method, although have found that clicking the relevant cell with my mouse between "&"s causes much stress on my left hand trying to hold down "shift" and "7" cheers guys