|Subject:||Re: extract numbers from text or a constant|
|Posted by:||Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)|
|Date:||Sun, 14 May 2006|
=IF( LEFT(P4,2)="NW", VALUE(MID(P4,3,255)))
so NW is the only option?
Excel 95 - Excel 2007
Northwest Excel Solutions
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"Stephanie" <Stephan…@discussions.microsoft.com> wrote in message
>I have cell with NW123456 in p4. I am using the following to remove the
> =if left(p4,2)="NW" or "nw", Value(left(p4)-2)
> But it does not work. The formula auditor states I am trying to evaluate
> Thank you for any help.
extract numbers from text or a constant posted by Stephanie on Sun, 14 May 2006