Share via

Concatenate with an array formula?

Anonymous
2012-08-14T17:04:43+00:00

Let's say i want to concatenate the values in 20 columns in a formula using either & or concatenate; is there a way to do this with an array formula so I don't have to individually select each cell to concatentate? TIA

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2012-08-15T01:57:58+00:00

    Hi,

    If you can download and install the following addin - http://download.cnet.com/Morefunc/3000-2077_4-10423159.html, then you can use the MCONCAT() function like =MCONCAT(A1:T1,", ")

    Hope this helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2012-08-14T20:01:31+00:00

    Something like I have at http://www.cpearson.com/Excel/StringConcatenation.aspx

     

     

     

    Hello Chip,

    Normal mortals might be satisfied with:

    http://sulprobil.com/html/sbcat.html

    If a string is too long I really would like my UDF to fall over, by the way.

    Regards,

    Bernd

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-08-14T19:05:20+00:00

    Exactly, Chip!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-08-14T17:33:33+00:00

    If you mean something like....=CONCATENATE(A1:Z1)...to equate to A1&B1&C1...etc

    That can't be done with native Excel functions.

    VBA would be needed to create a User Defined Function (UDF).

    Was this answer helpful?

    0 comments