| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract numeric part of alphanumeric cell
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? |
| 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 | |||
Threaded Mode
