Masks in Excel

[D. Luprek]

I would like to create a mask of some sort in Excel. Suppose I have written
in one cell "10seconds" and I would like to use the value 10 from this cell
in a formula in a different cell. Is there any way I could mask out the
"seconds" in order to just use the numeric value? Any help would be great...
Thanks!

 

[Sandy Mann]

If you were to have a space between the number and the text then you could
use:

=--LEFT(A1,FIND(" ",A1))

to extact the number. You can then use it is a calculation like:

==--LEFT(A1,FIND(" ",A1))*B1


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Also if the text is always "Seconds" then you can apply a Custom format
like:

General " Seconds"

then when you enter the 10 it will display as "10 Seconds" but you can use
the cell reference as normal:

=A1*B1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk