remove text from cell containing numbers
If G22 contains your example, then:
=LEFT(G22,2) & "." & MID(G22,5,2)
will yield 6.30
--
Gary's Student
"Tim" wrote:
How can i remove the text from a cell to leave the mumbers?
I can remove it when there is only one block, IE 16m to read 16
But what about 16m 30s to read 16.30?
or even better as the above means 16minutes 30seconds i would love it to
read 16.50
|