Extract Data from Middle of Cell

[narrowgate88]

I have a table, and in Col E, I need to extract a value from the middle of a cell.

Cell E2 =

Please Login or Register  to view this content.

I need a result that gives me

Please Login or Register  to view this content.

.

The beginning of the field will always have

Please Login or Register  to view this content.

, but the value I'm trying to extract will either be 4 or 5 digits in length. So I don't know how to write a mid formula in my macro to do that.

[martindwilson]

one way
=SUBSTITUTE(MID(A1,FIND("+",A1)+1,255),"p)","")+0

[narrowgate88]

That worked. Now let me ask this. Some cells don't have this (+7.33p) piece. So now I need to incorporate this substitute formula into a larger formula.

Please Login or Register  to view this content.

To make matters more complicated Col E is text. So when I try to convert this to a number, it works fine except for the (+7.33p) cases where it results in #VALUE. So I don't know how to write my if formula to do all this. I'm attaching the file.

I'm wanting to put the results in a new col between E and F.

[martindwilson]

=IF(ISNUMBER(E2+0),E2+0,SUBSTITUTE(MID(E2,FIND("+",E2)+1,255),"p)","")+0)