- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- RE: extract numbers from text or a constant

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

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

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