|Subject:||RE: extract numbers from text or a constant|
|Posted by:||Gary''s Student|
|Date:||Sun, 14 May 2006|
> I have cell with NW123456 in p4. I am using the following to remove the nw.
> =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 a
> Thank you for any help.
extract numbers from text or a constant posted by Stephanie on Sun, 14 May 2006