Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: To CONCATENATE or Not to CONCATENATE

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Charlotte, NC USA
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •