Extract dates and times from text string

[Marklarbear]

Hi Brains Trust,

I'm looking for a formula/s to extract date, date & time from a text string in cell A1.

string in A1 is: ceSHIFT 19/12/2022 8:30 AM-19/12/2022 5:00 PM

so... in B1 it would show 19/12/2022 and in C1 it would show 19/12/2022 8:30 AM and in cell D1 it will show 19/12/2022 5:00 PM

I'm unable to load into the forum with XL2BB due to security restriction in place on my work PC...

 

[DanteAmor]

Try this:

Dante Amor
	A	B	C	D
1	string in A1 is: ceSHIFT 19/12/2022 8:30 AM-19/12/2022 5:00 PM	19/12/2022	19/12/2022 8:30 AM	19/12/2022 5:00 PM
Hoja3

Cell Formulas
Range	Formula
B1	B1	=MID(A1,SEARCH("??/??/",A1),10)
C1	C1	=MID(A1,SEARCH("??/??/",A1),SEARCH("-",A1)-SEARCH("??/??/",A1))
D1	D1	=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),99))

 

[Marklarbear]

Try this:

Dante Amor
	A	B	C	D
1	string in A1 is: ceSHIFT 19/12/2022 8:30 AM-19/12/2022 5:00 PM	19/12/2022	19/12/2022 8:30 AM	19/12/2022 5:00 PM
Hoja3

Cell Formulas
Range	Formula
B1	B1	=MID(A1,SEARCH("??/??/",A1),10)
C1	C1	=MID(A1,SEARCH("??/??/",A1),SEARCH("-",A1)-SEARCH("??/??/",A1))
D1	D1	=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),99))

worked brilliantly - cheers!!! have a great Xmas!