Home |
Search |
Today's Posts |
#1
|
|||
|
|||
*Issue* Concatenate dates in a large range of cells in a row.
I am having an issue concatenating a large amount of data from a row.
What I am trying to do is merge all of the data in each cell into one cell in the row. The data in the cells is a date format. Does anyone know a formula that will do this for me? The range is 365 cells in the row some cells have data and some do not but they look similar to the below with 1 date in each cell. 11/25/12| |11/23/12| |10/25/12| I want it to return this: 11/25/12, 11/23/12, 10/25/12 all in one cell "V2" for all the data in row 2 and so on. . If there is not data in the cell then it goes to the next. So if I had 365 cells with data in the row I want it to return 365 dates seperated by a comma in 1 cell. Any help would be much appreciated! I have attached a picture! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate large numbers of cells | Excel Discussion (Misc queries) | |||
concatenate with a varying range of cells | Excel Worksheet Functions | |||
concatenate cells by a given range | Excel Worksheet Functions | |||
Concatenate a Range of Cells | Excel Programming | |||
How to concatenate adjacent cells in a range without using &? | Excel Worksheet Functions |