| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull out numbers only in cell
I have cells that contain text and numbers. How can I pull just the numbers
out into a new cell. I would use the Right or Left function, but as you can see from below they are different lengths. Does this have to be done in Access? If so, how? Here is an example of my cells: LOT 0 - 2nd WAVE P/N 98416 (Qiqihar) LOT 0 - 2ND WAVE P/N 120144410 (Delong) DEDS-MECH-02 P/N 100136862 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull a selected segment of numbers/text from a large strin | Excel Worksheet Functions | |||
| Pull information based on a range of numbers | Excel Worksheet Functions | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
| Pull numbers from a cell | Excel Worksheet Functions | |||
| How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Threaded Mode
