| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Numbers froma Text String
Hi...I have a problem I've been working on for a while now...to no avail.
a2=200865346120565131TED STOCK THIGH HIGH XL 3922 I'm managed to get to a2=2008653461 b2=20565 c2=13 d2=131ted stock thigh high xl 3922 e2=ted stock thigh high xl 3922 Problem is D2 - I need the one after the three... It is not consistent in the database... But what is consistent is I need the one right before the text begins (some times it may be up to three numbers) all located before the text. Any help would be great! Thanks jules 01.20.09 -- Jules |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting a numbers from a text string | Excel Worksheet Functions | |||
| Extracting numbers from string of text | Excel Discussion (Misc queries) | |||
| extracting numbers within text string! | Excel Worksheet Functions | |||
| Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) | |||
| extracting numbers from string | Excel Discussion (Misc queries) | |||
Threaded Mode
