remove text from cell containing numbers
 

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

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

remove text from cell containing numbers
 

Try something like this:

Select the range of cells
<Edit<Replace
Find what: m
Replace with: (clear this field so it contains nothing)
Click the [Replace All] button

Leave the dialog open....

Find what: s
Replace with: /60
Click the [replace all] button

The values should now be numeric with a fraction format
Example: 16m 30s will become 16 1/5

Change the number format to Gereral or Number

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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