| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract numeric part of alphanumeric cell
ASAP Utilities, a free add-in available at www.asap-utilities.com has a built
in feature that will delete all alpha characters from a string. Vaya con Dios, Chuck, CABGx3 "Sarah (OGI)" wrote: Cell AR12 has a value that reads 'Visit 6 GWP'. In an adjacent cell, I would like to extract the numeric value of this text string. Any ideas re how I can do this through the use of a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract numbers from a alphanumeric cell | Excel Worksheet Functions | |||
| Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
| Function to extract numbers from an alphanumeric cell | Excel Worksheet Functions | |||
Hybrid Mode
