Forum Discussion
Trouble combining two cells into one
Hello,
I am trying to combine a date from cell A1 (=Today()) with a time from cell B1 (3:00:00 PM), but everything I try, I get:
"44001 3:00:00 PM" in C1
I've tried custom formatting, I've tried different ways to concatenate them, but I cannot get this to work. I need the date to always reflect today's date (hence using =Today()), and I need the time to always be 3:00 PM, and I need them both in the same cell formatted as:
"6/19/2020 3:00 PM"
Both cells I have formatted as DATE, to see if that mattered, but alas...
Anyone have any ideas?
4 Replies
- =TEXT(A1,"m/dd/yyyy")&" "&TEXT(B1,"hh:mm:ss")
That will deliver 6/19/2020 15:00:00
Then you can copy down the formula using autofill handle Combine data using the CONCAT function
-
Select the cell where you want to put the combined data.
-
Type =CONCAT(.
-
Select the cell you want to combine first.
Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
-
Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").
-
