Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine the contents of multiple cells in one cell?
I am putting together a form in Excel 2003 where several options can be
selected, and I want to combine the information in the selected cells in another cell with commas seperating the information. For example, I have one column with environmental hazards listed, one in each row (storage tanks, batteries, generaters), and in the next column the person filling out the form can select yes or no if that hazard is present. I want to take the information from the cells next to the cells that are marked yes, and put it together, separated with commas, in another cell in a different worksheet . If someone could please help, I would sure appreciate it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Spliting the contents of a cell to other cells | Excel Worksheet Functions | |||
Combine multiple cells into one cell range. | Excel Worksheet Functions | |||
How to combine text from multiple cells? | Excel Worksheet Functions | |||
city, state, zip from a single cell to multiple cells | Excel Discussion (Misc queries) |