| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract numbers from string
hello,
I am using the following code to extract numbers from a string http://www.ozgrid.com/VBA/ExtractNum.htm however when I have strings like WS123ABC45cft, I would like to extract only the first set of number"123". The code provided extracts "12345" Do you know how to correct the code? Please note that the number of numbers and letters are variables so I cannot use LEFT or RIGHT. thanks -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract numbers from a string of text | Excel Discussion (Misc queries) | |||
| extract numbers from a string | Excel Worksheet Functions | |||
| Only extract numbers from a string of text | Excel Discussion (Misc queries) | |||
| Extract Numbers From String | Excel Programming | |||
| Extract numbers from a string ? | Excel Programming | |||
Threaded Mode
