Concatenate Formula Text & DateTime, Exclude Time

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
2,102
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
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
FGH
2namedate/time formatexpected result
3john wick3/17/2023 8:45:17john wick3/17/2023
4michael6/20/2020 15:06:39michael6/20/2020
5sisca farah12/20/2021 15:24:24sisca farah12/20/2021
6lion big3/28/2023 13:56:33etc..
7jun malca04/11/2023 11:55
Sheet1

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

susant
 
Last edited:

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Upvote 0
Solution
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top