| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract numbers from a string of text
Hi,
Try this =MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,":",CHAR(7),2)) +1,7) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "marcella63" wrote: Need to extract just the numbers at then end of the string. 1300 · Inventory:1305.05 · Inventory Business to Business:1305.10 · B2B Inventory Contra 1300 · Inventory:1305.05 · Inventory Business to Business:1305.15 · B2B Inventory 1300 · Inventory:1310 · Inventory - Raw Materials:1310.05 · Inventory - Flavoring 1300 · Inventory:1310 · Inventory - Raw Materials:1310.10 · Inventory - Green Beans 1300 · Inventory:1310 · Inventory - Raw Materials:1310.15 · Loose Tea 1300 · Inventory:1320 · Inventory-Consumable Products:1320.05 · Chai Latte 1300 · Inventory:1320 · Inventory-Consumable Products:1320.10 · Cocoa 1300 · Inventory:1320 · Inventory-Consumable Products:1320.15 · Coffee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract text from string, leaving numbers and operators | Excel Discussion (Misc queries) | |||
| HOW DO I EXTRACT NUMBERS FROM TEXT STRING | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
