Converting text to numbers

[smithy0705]

Hi Guys

I have this date format as text and would like to convert it to just numbers:

This is what I have '3ys 7ms 15ds' and I would like to try and display it as a round number say 3.70 or 3.07 whichever works

TIA

 

[gaz_chops]

Maybe

=REPLACE((SUBSTITUTE(A1,"ys ",".")),FIND("ms",A1)-2,99,"")+0

 

[smithy0705]

Thank you so much this worked

 

[AlKey]

Or try these
To get 3.7
=LEFT(SUBSTITUTE(A1,"ys ","."),FIND("ms",A1)-3)/1
To get 3.07
=SUBSTITUTE(LEFT(A1,FIND("m",A1)-1),"ys ",".0")/1

Unknown
	A	B
1	3ys 7ms 15ds	3.7
2	3ys 7ms 15ds	3.07
Sheet3