Stripping Keywords out of a text string and placing into relevant columns

I want to take a text string, in this case a broker confirm for trading, and find Volume, direction of the deal (buy sell), counterparty (trading shop selling/buying from me). And place them in a format where these pieces of information are contained in their respective columns:

ABC Inc. Sell, XYZ Inc. Buy 25 Contracts of Oil Futures for September at 45 (dollars)


A B C D E F
Buy Sell Product Volume Delivery Price
ABC Inc. XYZ Inc. Oil Futures 25 September 45

The confirms have the same structure typically "Company A" buys, "Company B" sells, "volume" "Product" for "Delivery" at "Price"...

Any help would be very appreciated!!!!

Here is an example and what I would like to see... it may be too involved, but being able to parse quickly and efficiently would be great....

How bout we take it in another direction... for counterparty and product, is there a simple way to find if a text string contains a keyword found in a list of keywords... i.e. I only trade with about 20 counterparties and only trade rougly 7 products...

Sorry to have offended you/wasted your time... but what I'm finding is that your solution is quite constrained i.e. these are Instant messages and sometimes their formats vary... I've found that using a series of dynamic named ranges, search functions and if statements is working quite nicely for the the confirms. I realize my example may have not been REPRESENTATIVE enough, so I apologize. Now I have only two more variables I would like to parse out and I'm guessing the solution will be pretty easy. First is the "Volume" is a number followed by *mb (thousand barrels) or very rarely just a *k for thousand. Is there a way to find a number attached to either of these "suffixes" and return the number? example: Sean sells 25mb of frog oil, Luke buys... = 25. The second issue is price and may be a bit more involved and like I said the formula has to be dynamic in that it may have to find different formats. The example below are actual confirms and you can see their varying formats:

1:39:33 pm Sean sells 10mb of oct frog oil ice block futs at 97.625 = Expected result - 97.625
(ICE) Sean Sell, Karen Buy, 5mb Sep Whale Oil #5 65.50 = Expected result - 65.50
(Direct) Sean Buy, Oliver Sell 25mb Sep Horse Oil #4 96.25 = Expected Result - 96.25

I worry that if the time stamps come across as numbers they will be pulled as the pricing result, or the grade (in this case #5 and #4) will also bring about a false result.... Hopefully this is an easier fix than I'm imagining. thank you for your time.

Boom that worked like a charm! thanks for your patience and help!!!