Excel: Extract substring

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

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of October 16, 2014.

For more resources for Microsoft Excel