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