Forum Discussion
Combing date and time from two different cells into third cell
I am trying to combing a date from one column and a time from a second column into a third cell on another column. I've tried to Combine data with the ampersand symbol AND Combine the data using th...
Hi,
This is most likely being caused by a formatting issue.
You can try converting both cells to TEXT when referencing them using the TEXT function.
=TEXT(A1,"dd/mm/yyyy")&" "&TEXT(B1,"h:mm am/pm")
=5/21/2021 4:00pm
This is most likely being caused by a formatting issue.
You can try converting both cells to TEXT when referencing them using the TEXT function.
=TEXT(A1,"dd/mm/yyyy")&" "&TEXT(B1,"h:mm am/pm")
=5/21/2021 4:00pm