Hi I have a dataset in text such as:

Apples have been sold by Ben to Joe for 15£
Peach have been sold by Patrick to Jessica for 154£
Lemons have been sold by Mark to Hanna for 1544£

I was wondering if it would be posible to separete the information in columns such as that:

In Column A; have What has been sold
In Column B: Who sold it
In Coumb C: To whom it was sold
In columb D: How much was sold

I've tried to do the Data>Text to Columns and use spaces to break up the columns but it did not work as it grouped the data on the wrong way.


Any Help is more than welcome thanks!

Oh and is my first post so Hi to everyone and glad to be part of this forum!

Cheers!
Delac147