| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull Out Numbers From String
You have some good VBA solutions, so here's a formula solution:
With A1 containing text with some consecutive numbers in it. This formula extracts those numbers B1: =LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10000)))) Note: if there are no numbers, the formula returns 0 Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Curious" wrote: This column is comment. Numbers mixed with text in the cells. They look like Statue of liberty 12345 statue of liberty 12345 statue of liberty statue of liberty statue of liberty statue of liberty 12345 The number (product order code) could be anywhere. How do I pull out the numbers by formula or by VB code? Thanks in advance. HZ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull string before a certain character | Excel Discussion (Misc queries) | |||
| Formula to pull first word from text string in a column | Excel Worksheet Functions | |||
| pull numbers from text string | Excel Discussion (Misc queries) | |||
| Pull last word from a text string in Excel | Excel Worksheet Functions | |||
| Pull numbers from a cell | Excel Worksheet Functions | |||
Threaded Mode
