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