How to combine data like this. Date is not seen properly. M18190020 MH04 FU 1234 27/08/2019
S Shabbo Member Aug 27, 2019 #1 How to combine data like this. Date is not seen properly. M18190020MH04 FU 123427/08/2019
B bosco_yip Excel Ninja Aug 27, 2019 #2 Perhaps, =A1&"-"&B1&"-"&TEXT(C1,"dd/mm/yyy") Return : M18190020-MH04 FU 1234-27/08/2019 Regards