mike31z
01-30-2008, 06:31 PM
I am using excel version 2000. sp-3
I need to learn how to combine date from 9 cells in a row into a single cell. Some of the cell in the row may not have any data and some cell may have data in up to 4 different cells.
In the example I have attached.
Cell AI6 is the cell were I would like the combined data to appear.
The source cells are S6:AA6. as you can see my attempt using:
To combine text from multiple cells into one cell, use the & (ampersand) operator.
did not work.
Any help or ideas would be helpful
Mike in wisconsin
I need to learn how to combine date from 9 cells in a row into a single cell. Some of the cell in the row may not have any data and some cell may have data in up to 4 different cells.
In the example I have attached.
Cell AI6 is the cell were I would like the combined data to appear.
The source cells are S6:AA6. as you can see my attempt using:
To combine text from multiple cells into one cell, use the & (ampersand) operator.
did not work.
Any help or ideas would be helpful
Mike in wisconsin