Split records in text into different columns

Hi Experts,

I had a task to split 200 records in text into different columns using Find & search , mid , left , right function.

Request you to please look into this.I attached an excel sheet for reference.

Thanks