| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
extract numbers from text string
I have a column of cells with information in some of the cells only. the
information is text with numbers (the text can be of varying length), for example: C3 could contain: 1 avml 12 chml 1 special occasion. There could be as many as 12 variations in the string of text. I need to extract all the information into other cells, seperating the numbers from the text so H3 = 1 I3 = avml, etc. How do I do this with visual basic? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only extract numbers from a string of text | Excel Discussion (Misc queries) | |||
| How to extract decimal numbers e.g. $1.57 from alphanumeric string | 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
