Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximum concatenate (2003)

    I'm having problems concatenating at 30, so I am guessing this is the maximum? If so, how do I get around this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Maximum concatenate (2003)

    An Excel function can have a maximum of 30 arguments.

    However, you can use & to concatenate values:
    <code>
    =A1&A2&A3
    </code>
    or
    <code>
    ="Vegas"&" "&"Nath"
    </code>
    You can concatenate more than 30 values this way, you're limited by the maximum length of a formula (1,024 characters).

  3. #3

Posting Permissions

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