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
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