Results 1 to 16 of 16

Building a comma delimited string from Cell Range

Threaded View

Patchworks Building a comma delimited... 11-12-2008, 01:21 AM
sglife =concatenate(index(a:a,match(1... 11-12-2008, 02:39 AM
JBeaucaire That function only goes three... 11-12-2008, 03:01 AM
Patchworks sglife, thanks for your... 11-12-2008, 02:31 PM
JBeaucaire How to Create a UDF 11-12-2008, 03:00 PM
Patchworks Ok, I've done exactly as you... 11-12-2008, 05:43 PM
JBeaucaire The last instruction above... 11-12-2008, 08:04 PM
JBeaucaire Examples Of StringConcat ... 11-12-2008, 08:06 PM
Patchworks Ok, after messing with this a... 11-16-2008, 04:02 AM
JBeaucaire Works perfect. That is an... 11-16-2008, 04:40 AM
shg As JB says, it's an array... 11-16-2008, 12:03 PM
Patchworks Well, sorry for all the... 11-16-2008, 05:05 PM
Patchworks Guys, this array thing is way... 11-16-2008, 08:28 PM
shg Excel is a complex but... 11-17-2008, 12:00 AM
JBeaucaire I don't mean to "speechify"... 11-17-2008, 12:23 AM
Patchworks JBeaucaire, Thanks for the... 11-17-2008, 12:25 AM
  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    Building a comma delimited string from Cell Range

    I would like to build a comma-delimited string from a range of cells. I would like to be able to put a number in the cell next to the word to indicate whether or not to include the cell in the string. Once there is a number entered in column b, I would like to sort on column b.

    For example,

    word1 1
    word2 2
    word3 3
    word4

    I need a function to build a string to look like "word1,word2,word3"

    Thanks,

    g
    Last edited by Patchworks; 11-16-2008 at 08:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1