Thank you for your help. I copied all information into another sheet and
everything worked.
Thank you so much

--
Stephanie


"Stephanie" wrote:

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