Custom Function

[Maltraca1]

I am trying to locate or create a function which reads the number from a string.

The data in the cell is formatted as text in this fashion: Name-25

I would like to return in a new cell just the value of 25. How might I go about this?

[wa284sj]

lets say you've entered "name-25" in cell E10 if you type the formula
=RIGHT(E10,2) in another cell, you should get the result you asked for.

Regards Stuart.