| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alphanumeric
Dear sir
I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121, UIEIROIWS12556ERE545,ADAS15455212AD4564AD2 And so on. Now I want to extract number from this alphanumeric. Once I have seen a formula of (SUBSITUTE) in a site it was so simple that any body can use that formula. Its very short formula. Spouse a1:a1500 has alphanumeric data put the formula in B1 and drag this formula to B7. In B7 You will find the only number. If you can help me in this matter It Will Be most Appriciate Regards Hardeep -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200807/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ALPHANUMERIC | Excel Worksheet Functions | |||
| sort alphanumeric | Excel Discussion (Misc queries) | |||
| alphanumeric range | Excel Worksheet Functions | |||
| alphanumeric sorting | Excel Worksheet Functions | |||
| Sorting alphanumeric | Excel Discussion (Misc queries) | |||
Threaded Mode
