Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: =CONCATENATE

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ::

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

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
  •