extract numbers from text or a constant

Giganews Newsgroups
Subject: extract numbers from text or a constant
Posted by:  Stephanie
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
constant.

Thank you for any help.

--
Stephanie

Replies