Build a macro script that Converts pasted data to columns and remove few cells

Job ID: 35275687

Budget: ₹600 – ₹1,500 INR

<p> <img src="logsm.png" alt="Longtail boat in Thailand"></p>
Simple macro script that converts pasted data to columns

20/11/2022 12:29:52 2 N 13.95 13.95 USD 57 5 689 5 689 1 4111 0 Amazing people are here

I want to keep the date and time and first usd value 13.95 and last value of the (Amazing People are Here)