View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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