Excel formula/macro - How can I identify a 3 character word & then pull the entire sentence to an adjacent cell?
Posted on 2014-09-17
Hi. I have a cell with a lot of technology names.
I need to only pull sentences with EHR or EMR within the sentence, and then pull the entire sentence (between the commas) into an adjacent cell.
,Allscripts Enterprise EHR, Cerner, Cerner Millennium, Certify HealthDock,
I want to pull only "Allscripts Enterprise EHR" in another cell.