1-If one number only to right:
=VALUE(RIGHT(A1,1))
2-UDF in a module:
Function NumChaine(chaine)
temp = ""
For i = 1 To Len(chaine)
c = Mid(chaine, i, 1)
If c = "0" And c <= "9" Then temp = temp & c
Next i
NumChaine = Val(temp)
End Function
=NumChaine(A1)
3- SUBSTITUTE PRS and V with empty string:
=VALUE(SUBSTITUTE(SUBSTITUTE(A1,"PRS",""),"V",""))
http://cjoint.com/?bkj256aD68
JB
http://boisgontierjacques.free.fr/
On 10 jan, 05:07, TEK wrote:
I'm looking for a formula that ignores text, but counts numerical values
within the same cell. *This formula applies to a spreadsheet that tracks
vacation/sick time by entering a letter and numeric value. *For example,
entering V6 in a cell would mean this particular individual has taken 6 hours
of vacation time. *Not all codes are prefaced with a single letter, however. *
Such as PRS8, which would equate to 8 hours of personal time. *Any help would
be appreciated.