=IF( LEFT(P4,2)="NW", VALUE(MID(P4,3,255)))

so NW is the only option?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Stephanie" wrote in message
...
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