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.