Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet with one column (let's call it column 1) that has
numbers as identifers. In column 1, there may be several occurences of the same number. In the row for the number, there is another column that contains text (let's call it column 2). Here's what I want to do. I want to combine all the text from each column 2 occurence related to the number in column 1. So, if column 1 has a row with the number 333 and column 2 in that row has the text "Hello" and another row in column 1 also has number 333 but the column 2 text is "What", I want to have output in one cell = Hello What with the column 1 cell on the same row showing 333. Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Cell Contents (Part 2) | Excel Discussion (Misc queries) | |||
Combining Cell Contents | Excel Discussion (Misc queries) | |||
Combining Cell Contents | Excel Worksheet Functions | |||
Combining Cell Contents - entire columns | Excel Worksheet Functions | |||
Combining cell contents when there is content to combine | Excel Discussion (Misc queries) |