Combining text from 2 cells wrapped line for line.

[Keljoe2804]

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

 

[Fluff]

How about

=TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy")

 

[Keljoe2804]

How about

=TEXT(A2,"mm/dd/yy")&" - "&TEXT(B2,"mm/dd/yy")

As mentioned that just creates the result I don't want
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
Instead of this
4/9/23 - 2/18/23
3/23/23 - 3/2/23
12/1/23 - 3/5/23

 

[Fluff]

If that is not what you are after, then please post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

What you have posted tells us nothing at-all.

 

[Keljoe2804]

I'm sorry, as much as I'd like to use that tool, I'm on a company computer with very strict limits. I feel like the sample data I provided was pretty clear, but hopefully this provides some clarification.

I have the date log column and the date it changed in another column as well as date dropped. What I want is the final column to the right to contain all of the data from the 3 columns on the left. However some cells have multiple dates with wrapped text and when I try to combine them I get the issue I explained above, where it will first list all the contents from the first column then separate it with a "-" and then it list all of the contents of the next cell. The format I'm looking for is for it to pull the first date from the first column then add the "-" delimiter and pull the first date from the next column, then wrap the text or use char(10), pull the 2nd date from the first column place the "-" delimiter and pull the 2nd date from the 2nd column, an so on. At the end of that, if there is a date dropped it will say "Date Dropped on" and the date from the Date Dropped column.

Date Log | Date Changed | | Final Log Column

 

[Fluff]

I'm on a company computer with very strict limits.

Fair enough. Can you just copy/paste the cells to the board.

 

[Fluff]

Also what version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Keljoe2804]

Also what version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

OK done, thanks for the heads up. I'm using 365 and I use Power M Query and VBA

 

[Fluff]

Thanks for that.
How about

=TEXTJOIN(CHAR(10),,TEXTSPLIT(A2,CHAR(10))&"-"&TEXTSPLIT(B2,CHAR(10)))

 

[Keljoe2804]

Thanks for that.
How about

=TEXTJOIN(CHAR(10),,TEXTSPLIT(A2,CHAR(10))&"-"&TEXTSPLIT(B2,CHAR(10)))

So it still pulls all contents from cell 1 and then pulls all contents from cell 2. I need it to basically run back and forth between both cells.

Like this: