| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extract numbers from a string
Hello,
We import strings of numbers into a spreadsheet looking like this:- 12Rev999,nextrev456 124Rev8888,nextrev1234 In practice the numbers can be any length from 1 to 4 numbers and there are always three groups. I need to extract these numbers which are in Column A to Column C nearly forgot to mention the numbers in this format are text and I need them as numbers. Hope you can help. D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract numbers from text string | New Users to Excel | |||
| Only extract numbers from a string of text | Excel Discussion (Misc queries) | |||
| EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
| Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Threaded Mode
