Glad to help! Thanks for the feedback.

Biff

"SWBodager" wrote in message
...
Thank you very much for your help. This worked perfectly.

"Biff" wrote:

Hi!

Try this:

Assume your data is in the range A1:A100.

In B1 enter this formula and copy down as needed:

=LOOKUP(1000,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

Biff

"SWBodager" wrote in message
...
How can I remove all non-numeric characters from a cell? I am trying
to
figure final grades for all the students in our school. The cells that
I
am
working with contain the percentage and the appropriate letter grade
(i.e.
80
C+, 85B, 101 A+, etc.) The grades can be two or three digit numeric and
one
or two characters (may or may not have a space seperating the numbers
from
the leters). Thanks for any help on this,
Scott Bodager )