Results 1 to 3 of 3

Thread: Concatenate array string

  1. #1
    Junior Member
    Join Date
    Sep 2011
    Posts
    3
    Rep Power
    0

    Concatenate array string

    Is it possible to concatenate the the output of an array by excel formula?
    e.g., my array output is {"0";"f";"e";"w";"3";"2";"1";"m";"a";"k";"e";"8";" 7";"6";"m";"a";"n";"y"}
    i want the output as 0few321make876many

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi Tushar,

    Welcome to ExcelFox !!!

    AFIK, it's not possible. I could be wrong.

    BTW, you can try Rick's UDF.

    http://www.excelfox.com/forum/f22/fl...-function-313/
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi

    Since your original question has been answered, I moved your new query to a new thread. http://www.excelfox.com/forum/f2/ext...ic-values-566/
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. LookUp Value and Concatenate All Found Results
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 48
    Last Post: 10-31-2019, 07:00 AM
  2. Loop to two columns and Concatenate values
    By ivandgreat in forum Excel Help
    Replies: 15
    Last Post: 04-14-2013, 08:20 PM
  3. Function to Concatenate Values
    By Admin in forum Download Center
    Replies: 1
    Last Post: 12-13-2012, 11:38 AM
  4. Concatenate multiple values
    By mcpizzle in forum Excel Help
    Replies: 3
    Last Post: 08-30-2012, 04:03 PM
  5. Replies: 10
    Last Post: 04-07-2012, 05:33 AM

Posting Permissions

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