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