| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting mixed chains of numbers and letters
Is there a way to sum the numerical values in a chain that includes numbers
and letters. Example. If I have a chain such as "M4G3M4P0" is there something I can do so that excel will sum the numerical values? Note: the chains I am working with are sometimes quite long (up to 25 characters) but almost always go letter-number-letter-number- and so on. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I receive Exel file it is mixed numbers & letters Not English | Excel Discussion (Misc queries) | |||
| Counting how many numbers and letters appear in a particular row | Excel Discussion (Misc queries) | |||
| The order of numbers mixed with letters | Excel Discussion (Misc queries) | |||
| Sort mixed numbers/letters | Excel Discussion (Misc queries) | |||
| Counting numbers and letters | Excel Programming | |||
Threaded Mode
