remove text from cell containing numbers

T

Tim

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
 
G

Gary''s Student

If G22 contains your example, then:


=LEFT(G22,2) & "." & MID(G22,5,2)
will yield 6.30
 
R

Ron Coderre

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
 
Top