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