Compiling list of field values

[gouffre]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a column each cell of which contains a list of words deliniated by commas. I would like to compile a list of the words in all the cells of the column. Example:

three cells containing

dog,cat

horse,mouse

bird

will return the list dog,cat,horse,mouse,bird

 

[CyberTaz]

If your description of the current data is accurate, one way [assuming the
data to be in cells D10, D12 & D14] would be to enter this in the cell where
you want the content of those cells to be combined:

=CONCATENATE(D10&", "&D12&", "&D14)
[Note that there is a space following each comma]

I'm not sure, though, why you're trying to stuff multiple items into a
single cell. Most often the objective is to split each item into a cell of
its own so it will be useful in more ways... It's always easier to pull data
together than it is to split it apart

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

If your description of the current data is accurate, one way [assuming the
data to be in cells D10, D12 & D14] would be to enter this in the cell where
you want the content of those cells to be combined:

=CONCATENATE(D10&", "&D12&", "&D14)
[Note that there is a space following each comma]

I'm not sure, though, why you're trying to stuff multiple items into a
single cell. Most often the objective is to split each item into a cell of
its own so it will be useful in more ways... It's always easier to pull data
together than it is to split it apart

Note that while Bob's solution will work, it's rather
belt-and-suspenders.

=D10 & "," & D12 & "," & D14

will work fine, and save a function call, or

=CONCATENATE(D10, ",", D12, ",", D14)

wil also work.

OTOH, since the OP's using XL04, this may be of interest:

http://mcgimpsey.com/excel/udfs/multicat.html

Note that I also committed redundancy back when I wrote that page.