| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
remove non-numeric characters from a cell
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 ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
| Maximum characters that can be displayed in a cell | Excel Discussion (Misc queries) | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| Visible cell characters | Excel Discussion (Misc queries) | |||
| #### error if cell has more than 255 characters | Excel Discussion (Misc queries) | |||
Threaded Mode
