Extracting parts of a text string

[-emma-]

Hey all,

This is how we get things emailed to us at work

Jul 17, ‘08 10:22 Your accountant has received payment of $50,000 from Buisness1.

Jul 18, ‘08 10:29 Your accountant has received payment of $5 from Buisness1675.

As you can see the buisness names change as do the amounts.

I need a very simple formula that when this is pasted into a cell (eg cell A1)...in its raw form...cell b1 shows the buisness and c3 shows the amount.

Any ideas would be good. Thanks.

[daddylonglegs]

For the amount try

=REPLACE(LEFT(A1,FIND(" from ",A1)-1),1,FIND("$",A1),"")+0

and the business

=REPLACE(A1,1,FIND(" from ",A1)+5,"")

[-emma-]

Works great...thanks x