Data Separation

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

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

or use PowerQuery (Get&Transform)

Here is a Workbook Sample, so you can get a better idea of what I need, I've also attached the real data I want to break down.


Again, any help is appreciated!


And many thanks to all that replied!


Cheers,
delac147

Your original data is mixed like example ?

Maybe like this one:

Great! That works wonderfully! Much appreciated!

Cheers!

?????
which one

Thanks, Everyone!

Here @GlennKennedy solved it for me!

Thanks for all the help!