Text format and Date format (before converted) in a single cell i.e. Closed 44616 - How do I partially change the 44616 to date format?

[jjkh58]

Hi Guys,

I have a cell with Text format + Date format ( Before properly formatted) in a single cell. I would like to change this to e.g. Closed 22/02/2022

How to I partially change the 44616 part to short date format?

Thanks in advance,

Closed 44616

 

[jtakw]

Hi,

Is one of these what you mean:

Book3.xlsx
	A	B	C
1	Closed	2/24/2022	Closed 24/02/2022
2	Closed	44616	Closed 24/02/2022
3	Closed 44616		Closed 24/02/2022
Sheet1028

Cell Formulas
Range	Formula
C1:C2	C1	=A1&TEXT(B1," dd/mm/yyyy")
C3	C3	=LEFT(A3,FIND(" ",A3))&TEXT(MID(A3,FIND(" ",A3),9),"dd/mm/yyyy")