Want to extra text before and after specific punctuation marks

[MissQuestion]

Hello,
I am trying to create a new table automatically from a lengthy table I export from my systems.
The table is like this

Relation to - column C
Problem - Column D
Plan to solve it and updates - Column E

Column E is the one I am trying to use formulas to decrease but I cannot get anywhere. It is like this
"Jenny Marks, Manager, to prepare slides. Update on 20Jan2023: Jenny Prepared the slides but missed the final page.
20Jan23 Jenny Marks, Manager, to prepare final page.
Update on 10Mar2023: Jenny finalised slides. James Connor, Director, to approve slides."
The above always has the same things between changes I.e. Name surname, role, "to" task.

I want to extract to Column E to separate sections:
The latest planned action should go to Column O.
The relevant person and their role. for the last action should go to Column Q.

I have given an example below of how it should look like based on my above example:
Column O (remove the "to " from it and capitalise first letter of word afterwards)
Approve slides.
Column Q: James Connor, Director

I have managed to get my formulas to partially work but sometimes they don't seem to do so...

Happy to provide more examples! Thank you !

 

[James006]

Hi,
With your string located in cell A1, you can test :

=RIGHT(SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND("to ",A1)+3),""),LEN(SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND("to ",A1)+3),""))-(FIND(".",SUBSTITUTE(A1,RIGHT(A1,LEN(A1)-FIND("to ",A1)+3),""))+1))

and

=PROPER(RIGHT(A1,LEN(A1)-(FIND("to ",A1)+2)))