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.
Value in E2 is 0.0(+7.33p) and result needs to be 7.33
Value in E3 is 9.87 and result needs to be 9.87
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.
Bookmarks