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

Michael

Thanks. I can use a helper column but I looked it over and tried to
understand but it might be too complicated for my limited excel knwledge.
I look at it again but i'm hoping there might be a simpler way.
Basically, I need to eliminate all the characters in the cell that aren't
numbers (letters and punctuation).

thanks.

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

Sorry about that Jeremy. I don't understand it myself. Maybe one of the
MVP's will come up with some VBA code for you.
--
Sincerely, Michael Colvin


"jeremy via OfficeKB.com" wrote:

Michael

Thanks. I can use a helper column but I looked it over and tried to
understand but it might be too complicated for my limited excel knwledge.
I look at it again but i'm hoping there might be a simpler way.
Basically, I need to eliminate all the characters in the cell that aren't
numbers (letters and punctuation).

thanks.

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