Hi there,


I have a question. I have an folder with column A and B. And now I would like to have a column C wich combines the contents of A and B.



I tried like this: =A1&" "&B1


That works usualy. But not in this case - because column A includes a date. The result looks like below. I don't get the Dates correct.


Thanks for enlightning.


Sorry, I can't fill in my sheet. I schow you:


01.01.24 Test2 45292 Test2
06.03.24 Test3 45357 Test3

Try formatting Col C regarding the date. Right click column / Format / then select date.

Thanks for the reply - but it is not working. I allready tried that.

What is format of cells in columns A and B (as example of cells A1 and B1)?
And give an example of some values in those columns (e.g. in A1 and B1)! NB! In case the cell format is date, give what you see there!

And then show, what must the formula in column C return (as example in cell C1)

=TEXT(A1,"mm.dd.yy ")&B1

It always helps to post a small sample sheet with some data and manually mocked-up expected results ( no pics please).All the solutions above are OK, results all depend on your layout

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post