Problem separating a long string into four separate fields?

Many thanks Alkey. Works almost perfectly with the real data. There are though just a few records that still don't work. It is where the string and particularly the course title are too long so spill into the other cells. The maximum characters of a course title including spaces appears to be 126 and the maximum string length including spaces appears to be 161. Can that help you to to polish it off?

As an aside, this exercise has proved that the data analysis course I did has taught me what can be done but the complex formulae, unless I am working regularly with complex datasets, might be impractical for me to take time to learn as so much practice would be required? But once the real world problem is solved (nearly!) then I can still learn on YouTube about TRIM SUBSTITUTE SEARCH etc and help me get how you did it and what is possible in future, but perhaps only with the help of your good selves on this forum? It might be best to simply ask for some code as required as in this case though of course I will learn what is doable?