| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract digits
I have a set of strings that contain digits at the right end, such as:
s1 = "abcd1234" s2 = "g10" s3 = "yyy19123" The data will always contain alpha chars on the left, and digits on the right. What's a fast way to quickly extract the digits of each string? thanks -Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I extract the last three digits from each cell in column? | Excel Discussion (Misc queries) | |||
| To extract the number if there is niumeric in right most digits | Excel Discussion (Misc queries) | |||
| how to extract digits from a row of numbers | Excel Worksheet Functions | |||
| I need to extract the first 3 digits from a cell (ex: AAG12345)? | Excel Worksheet Functions | |||
| Extract Digits Questions | Excel Programming | |||
Threaded Mode
