Good day everyone,

Is there a formula that removes unwanted text before and after specific word(s) within a cell? See below for an example.

"Enteredon02/11/2008at15:12:12byAdamHeskett:Clientinqonstatusofswitchingtofaxclient.EverythinghadbeenchangedinPASSaccordinglyexceptremovinghisnamefrcalllistforinput.Also,refaxedcoversheetstoclienttouseeachtimehefaxesinpayroll.Enteredon10/22/2007at14:22:44byparkerti:CLIENTwillbefaxinginpayrollgoingforward.Enteredon10/22/2007at10:47:04byLucyFatovic:NotesadvisethatclientwillbeafaxclientbutthecompanyhasbeenchangedtoaRUnAsIs.Justwanttoconfirmastowhichsetupheshouldbe.Enteredon10/11/2007at14:55:47byparkerti"

I highlighted & underlined the unwanted text (in this case it's the time) after the text "Enteredon02/11/2008at" and before the word "by". Within this cell, there are 4 unwanted texts that should be removed.

Your help is appreciated.
Statsman