Comining Columns of Dates into a Single Cell

[kbrewer9]

I'm new to VB and this forum. I have a spreadsheet with columns of dates that I need to combine into a single cell that is comma delimited that keeps the date format. Is there a simple solution?

[stnkynts]

Yes, but you gave such little information that I had to make a ton of assumptions. The odds of this working for your specific needs is very unlikely but it does do as you requested.

Please Login or Register  to view this content.

[kbrewer9]

It did not work. Here is an example of what I'm trying to do:

Col A Col B Col C Col D
5/24/2016 5/24/2022 5/24/2026 5/24/2027
6/18/2016 6/18/2024 6/18/2027
12/28/2014 6/28/2017 6/28/2023 6/28/2027

I need each row to be combined based on the data and separated by a comma and space. If there is no data in that column, it would need to be ignored.

[Kingali]

Hi there,
you could try this, it assumes you have two columns of dates and the third, adjacent column where the dates are joined.

Please Login or Register  to view this content.

Repeat for as many rows of dates.
There are probably many other ways, but you have a starting point.

[kbrewer9]

How do I change it for a range of data instead of just 2 columns?

[stnkynts]

Try:

Please Login or Register  to view this content.