| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull Out Numbers From String
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 | |||
![Curious[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
