Previous Topic Next Topic

Assistance with Formula

Closed
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Sep 3, 2010 at 12:58 PM
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010 - Sep 3, 2010 at 01:44 PM
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 response

Answer 1 / 1
DCecil07 Posts 30 Registration date Monday March 15, 2010 Status Member Last seen September 15, 2010
Sep 3, 2010 at 01:44 PM
I figured it out, Thanks.

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
You have guessed the code too many times. Contact support
nanosama95 -
Komu -

4 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses