Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Star Lounger
    Join Date
    Oct 2012
    Posts
    51
    Thanks
    1
    Thanked 7 Times in 7 Posts
    Hi

    Not my position to say, but should you not start your own thread instead of hijacking someone else's thread!

    Quote Originally Posted by jpzinn View Post
    Retired Geek, Is there any advantage to using the Concatenate function over something like =A2 & " " & A3?

  2. #17
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    Quote Originally Posted by jpzinn View Post
    Retired Geek, Is there any advantage to using the Concatenate function over something like =A2 & " " & A3?
    JP,

    As with most things computer there are multiple ways to accomplish the same task. Choose which ever works best for you. I like Concatenate because the intention is much clearer, to me at least, when I go back months/years later and look at the formula.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #18
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    I prefer the ampersand (&) to the fully name, since it is less characters to type. As RetiredGeek indicates it is preference. It is akin to the choice of:
    =A1+A4+A6

    or

    =Sum(A1,A4, A6)

    Steve

Page 2 of 2 FirstFirst 12

Posting Permissions

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