Keljoe2804
New Member
- Joined
- Nov 5, 2014
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
I've created a log system for changes to my spreadsheet. In one column I have a history of due dates, in the other column I have the date they changed. See below.
This is one Cell
Due Date | Date Changed
4/9/23 2/18/23
3/23/23 3/2/23
12/1/23 3/5/23
What I'd like to do is combine these into one cell
4/9/23 - 2/18/23
3/23/23 - 3/2/23
12/1/23 - 3/5/23
With the common methods of combining cells I get this
4/9/23
3/23/23
12/1/23 - 2/18/23
3/2/23
3/5/23
VBA or formula is fine. I can run VBA on changes.
Thanks
This is one Cell
Due Date | Date Changed
4/9/23 2/18/23
3/23/23 3/2/23
12/1/23 3/5/23
What I'd like to do is combine these into one cell
4/9/23 - 2/18/23
3/23/23 - 3/2/23
12/1/23 - 3/5/23
With the common methods of combining cells I get this
4/9/23
3/23/23
12/1/23 - 2/18/23
3/2/23
3/5/23
VBA or formula is fine. I can run VBA on changes.
Thanks