To CONCATENATE or Not to CONCATENATE

Gary_E · Feb 21st, 2002, 08:33 PM

General question
Why use a CONCATENATE formula when a simple string can give you the exact same results. Are there any benfits using CONCATENATE instead of a string. Any drawbacks to either. A string seems to be a lot easier to view

Sample formulas
=CONCATENATE(B1,C1)
=B1&C1

Juan Pablo González · Feb 21st, 2002, 08:58 PM

Just "easyness" (That's not even a word, is it ?)

Just like there exists some formulas that no one ever use (But can be very useful) like PRODUCT, EVEN, ODD, FALSE (I didn't even know there was a function for this one !), but, some users will "need" them to understand things better.

NateO · Feb 21st, 2002, 09:00 PM

FYI:

Main Entry: 1con.cat.e.nate
Pronunciation: kän-'ka-t&-n&t, k&n-
Function: adjective
Etymology: Middle English, from Late Latin concatenatus, past participle of concatenare to link together, from Latin com- + catena chain
Date: 15th century
: linked together

Main Entry: 2concatenate
Pronunciation: -"nAt
Function: transitive verb
Date: 1598
Inflected Form(s): -nat.ed; -nat.ing
: to link together in a series or chain
- con.cat.e.na.tion /(")k@n-"ka-t&-'nA-sh&n, k&n-/ noun

Nothing quite like "nating" it!
Cheers,

Nate

[ This Message was edited by: NateO on 2002-02-21 20:31 ]

Feb 21st, 2002, 08:33 PM	#1
Gary_E Board Regular Join Date: Feb 2002 Location: Charlotte, NC USA Posts: 108	General question Why use a CONCATENATE formula when a simple string can give you the exact same results. Are there any benfits using CONCATENATE instead of a string. Any drawbacks to either. A string seems to be a lot easier to view Sample formulas =CONCATENATE(B1,C1) =B1&C1 __________________ Thxs for tips - this place is a great source for tips & tricks Gary

Feb 21st, 2002, 08:58 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Just "easyness" (That's not even a word, is it ?) Just like there exists some formulas that no one ever use (But can be very useful) like PRODUCT, EVEN, ODD, FALSE (I didn't even know there was a function for this one !), but, some users will "need" them to understand things better. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Feb 21st, 2002, 09:00 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	FYI: Main Entry: 1con.cat.e.nate Pronunciation: kän-'ka-t&-n&t, k&n- Function: adjective Etymology: Middle English, from Late Latin concatenatus, past participle of concatenare to link together, from Latin com- + catena chain Date: 15th century : linked together Main Entry: 2concatenate Pronunciation: -"nAt Function: transitive verb Date: 1598 Inflected Form(s): -nat.ed; -nat.ing : to link together in a series or chain - con.cat.e.na.tion /(")k@n-"ka-t&-'nA-sh&n, k&n-/ noun Nothing quite like "nating" it! Cheers, Nate [ This Message was edited by: NateO on 2002-02-21 20:31 ]