I would like to know what can i do to convert a Text in a number I want. What
is the formula for this?, cause I can't find it. For Example:

Convert "VA-30" in the number "30", and that everytime I write that text, in
the cell beside appears 30

IF the number is always the right two digits, you could use this formula in
column B to modify column A where you type

=RIGHT(A1,2)*1

--
Best Regards,

Luke M


"FABIOZ28" wrote:

I would like to know what can i do to convert a Text in a number I want. What
is the formula for this?, cause I can't find it. For Example:

Convert "VA-30" in the number "30", and that everytime I write that text, in
the cell beside appears 30

On Thu, 6 Dec 2007 11:04:03 -0800, FABIOZ28
wrote:

I would like to know what can i do to convert a Text in a number I want. What
is the formula for this?, cause I can't find it. For Example:

Convert "VA-30" in the number "30", and that everytime I write that text, in
the cell beside appears 30

If the "number" is always the last two characters of the string:

=--right(a1,2)

A more general solution:

=--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),255)




--ron

If the number you are seeking always follows a dash, then no matter how many
digits it contains, this should work.

=MID(A1,FIND("-",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3




"FABIOZ28" wrote:

I would like to know what can i do to convert a Text in a number I want. What
is the formula for this?, cause I can't find it. For Example:

Convert "VA-30" in the number "30", and that everytime I write that text, in
the cell beside appears 30