| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract numbers from a code
Is it possible to extract by formula numbers from a code, for example
Code Number AS12345WQ 12345 F87654321LD 87654321 HN123 123 I want to be able to take just the numbers from the code and place them in the column next to it I've tried playing around with Right, Left and Len but the problem i'm having is there could be any number of letters at the begining or end of the code thanks Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract zip code from a 1 cell adress line? | Excel Discussion (Misc queries) | |||
| vba code for excel to extract data from txt file | New Users to Excel | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) | |||
Threaded Mode
