| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy numeric section of cell from alpha-numeric cell
Can anyone help with a formula to separate a field containing numbers and
letters into numbers per below? I only know how to use for eg =left(X,x) but that isn't helpful as different fields have different number of numeric charcters. 123ABC - 123 1234DEF - 1234 12GH - 12 -- ACCAguy -- ACCAguy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent alpha character in numeric cell | Excel Discussion (Misc queries) | |||
| subtract from numeric cell when alpha cell is occupied | Excel Worksheet Functions | |||
| How do I restrict entry into a cell to only alpha/numeric? | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| Can you ID a cell that has both Alpha AND Numeric characters? | Excel Worksheet Functions | |||
Threaded Mode
