Extract substring

[kd12345]

How do I extract a substring in the following example?:


Cell A1 = WATER IBC - P275G-1
Result needed = 275
Text and number of characters in each cell will vary, so I need to find the position "- P" for each cell then return the 3 numbers after P.
I

 

[Rick Rothstein]

Number of characters before and after " - P" & " - SS" strings both vary.

I wasn't referring to number of characters... I meant "numbers"... if there won't be a number (digits) in the text before the dash, then this relatively simple formula would work...

=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),3)