Prev: "Do you want to update" msg
Next: Formula for multiple criteria on 2 worksheets
From: Mike H on 27 May 2010 16:48
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
>
From: Huber57 on 27 May 2010 16:53
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
>
 | 
Pages: 1
Prev: "Do you want to update" msg
Next: Formula for multiple criteria on 2 worksheets