Hi Jereemy.
If you can use a helper column to first extract the numeric part of your
text before applying your test, the following site may be of use:
http://www.dicks-blog.com/archives/2...rmulas-part-1/
HTH
--
Sincerely, Michael Colvin


"jeremy via OfficeKB.com" wrote:

Sorry...it looks like always 2 letter (before or after). Another problem
is that ofter the number have an apostrophy (sp?) in front....

--
Message posted via http://www.officekb.com