Text Cleanup

Hi. I am having trouble with “dirty data” I have passenger names in a database spelt any which way…

eg; Samuel/Liam Mr or Samuel Liam Mr or SamuelLiam Mr or Samuel L Mr

How do I clean this data. Please help !!!!
Thank you