| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove alpha or non-numeric characters from cell
I have columns of data (one for each employee) each cell per column
represents a date and in each cell is a summary of the report each employee is working on. I am looking for a formula to remove all non-numerical charactes from a given cell. For my reports, I only need to identify or extract all the numeric characters which are the report ids. All the numbers end with ".##" Cell Entry: 635.09 -LR (MG) 672.09 - LR (KM) 31.08-R I need to extract only the number so I end up with: 635.09 672.09 31.08 with spaces added between each number. Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A validation rule on Alpha and Numeric characters | Excel Worksheet Functions | |||
| Using a cell w/Alpha numeric characters in mulplication formula | Excel Worksheet Functions | |||
| Can you ID a cell that has both Alpha AND Numeric characters? | Excel Worksheet Functions | |||
| remove non-numeric characters from a cell | Excel Discussion (Misc queries) | |||
| Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions | |||
Threaded Mode
