Extract Number from End of Text?

[slam]

I have a list of text containing 1 letter, followed by 1, 2, or 3 numbers (no space), and I am looking to extract the numbers:

For instance:

P8
P101
P39

would become

8
101
39

Any help would be greatly appreciated.

Thank you

 

[gaz_chops]

Maybe

=SUBSTITUTE(A1,LEFT(A1,1),"")

 

[slam]

Perfect, thanks!

 

[gaz_chops]

You're welcome.

 

[István Hirsch]

Or...

=MID(A1,2,3)