Extract number from a string

[vidyavallaba]

Hi all,

I need a formula to extract number from a string



example:v12

from the above i need the number(can be more than two digits) which appears after the character v

 

[G_Sereez]

Lets say that example:v12 is in cell A1.

in cell B1 put the following formula.

=RIGHT(A1,(LEN(A1)-FIND("v",A1,1)))