muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- 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
my target in cell H3 down
i want using concatenate or maybe textjoin formula
thank for your helping
susant
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
Last edited: