RE: extract numbers from text or a constant

Giganews Newsgroups
Subject: RE: extract numbers from text or a constant
Posted by:  Gary''s Student
Date: Sun, 14 May 2006

=--RIGHT(P4,LEN(P4)-2)

will work

--
Gary's Student

"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

Replies

In response to

extract numbers from text or a constant posted by Stephanie on Sun, 14 May 2006