ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extract numbers from a string of text (https://www.excelbanter.com/excel-discussion-misc-queries/264626-extract-numbers-string-text.html)

marcella63

Extract numbers from a string of text
 
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



All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com