Concatenate Formula Text & DateTime, Exclude Time

[muhammad susanto]

hi all.

how to joint 2 data in different cell using concatenate formula
1. data first, contains text
2. data second in date/time format with (mm/dd/yyyy.......)

i want to joint only name and date only not include time

Book1
	F	G	H
2	name	date/time format	expected result
3	john wick	3/17/2023 8:45:17	john wick3/17/2023
4	michael	6/20/2020 15:06:39	michael6/20/2020
5	sisca farah	12/20/2021 15:24:24	sisca farah12/20/2021
6	lion big	3/28/2023 13:56:33	etc..
7	jun malca	04/11/2023 11:55
Sheet1

my target in cell H3 down
i want using concatenate or maybe textjoin formula
thank for your helping

susant

 

[FormR]

Hi, you could try:

Book1
	A	B	C
1	name	date/time format	expected result
2	john wick	03/17/2023 08:45:17	john wick03/17/2023
3	michael	06/20/2020 15:06:39	michael06/20/2020
4	sisca farah	12/20/2021 15:24:24	sisca farah12/20/2021
5	lion big	03/28/2023 13:56:33	lion big03/28/2023
6	jun malca	04/11/2023 11:55:17	jun malca04/11/2023
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=CONCAT(A2,TEXT(B2,"mm/dd/yyyy"))

 

[muhammad susanto]

Hi, you could try:

Book1
	A	B	C
1	name	date/time format	expected result
2	john wick	03/17/2023 08:45:17	john wick03/17/2023
3	michael	06/20/2020 15:06:39	michael06/20/2020
4	sisca farah	12/20/2021 15:24:24	sisca farah12/20/2021
5	lion big	03/28/2023 13:56:33	lion big03/28/2023
6	jun malca	04/11/2023 11:55:17	jun malca04/11/2023
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=CONCAT(A2,TEXT(B2,"mm/dd/yyyy"))

hi FormR, thank you, working well.