| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count of numerical values within a cell
Dear,
I am looking for a formula which counts only the numerical values within a cell ignoring the special characters, text and anything else and gives the result in column B using a formula. Below is the example. A1 B1 Desired Result 1,804,672-4405,,,,//1,804,672-4405,,,, = 22 1,,201.368.5041,,,,//1,,201.368.5041,,,, = 22 1,503,601-4108 11 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only chart numerical values, not error values | Charts and Charting in Excel | |||
| Deleting numerical values within a cell | Excel Worksheet Functions | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| How do I count several non-numerical values in Excel? | Excel Discussion (Misc queries) | |||
| Extract one numerical value from single cell with multiple values? | Excel Worksheet Functions | |||
Threaded Mode
