Assistance with Formula

Closed
Report
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
-
Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010
-
Hello,

I need to come up with a formula to do the following....

Here is what I need, I need to go through column A and pull out anything dollar
amount that is followed by 'IN - '.

A2 - IN - $ 4900.00, IN/OON - $ 7300.00
A3 - IN/OON - $ 7300.00, IN - $ 5500.00
A4 - IN/OON - $ 7300.00, IN - $ 600.00

For Example:

A2 - $4900.00
A3 - $5500.00
A4 - $600.00

Can you please assist me with a formula?

Thanks so much! DC


1 reply

Posts
30
Registration date
Monday March 15, 2010
Status
Member
Last seen
September 15, 2010

I figured it out, Thanks.

=MID(A2,FIND("IN - ",A2)+5,9)