Extract numbers from a string of text
 

Marcella,

Use the 'text to columns' function under in the data ribbon (2007) or the
Data drop-down menu (2003). Use the 'fixed-width' selection and position the
column breaks on either side of the number you want to pull out. If that
doesn't work, use the 'delimited' option, using the colon as as the
delimiter. That will get you close. Then, find the one column with the
number you want and delimit it again with the 'space' as the delimiter. That
will get you the number you want. I am sure there is a formula you could use
but that is beyond my skill set.

HTH.

"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