Re: extract numbers from text or a constant

Giganews Newsgroups
Subject: Re: extract numbers from text or a constant
Posted by:  Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)
Date: Sun, 14 May 2006

=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" <Stephan…@discussions.microsoft.com> wrote in message
news:EE4115E4-EAF0-4FB5-ACB9-435A073464…@microsoft.com...
>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

None

In response to

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