Forum Discussion
Clean Data in a cell over multiple rows
Hello. Needing some help to clean data in excel. I have many rows of text in a single cell and I want to remove all of it except 1 specific line that starts with the word "mesh". Its a few hu...
=IFERROR(MID(E2,SEARCH("Mesh",E2),SEARCH(CHAR(10),E2,SEARCH("Mesh",E2))-SEARCH("Mesh",E2)),RIGHT(E2,LEN(E2)-SEARCH("Mesh",E2)+1))
This formula returns the intended result in my sample file.
This is great. Thanks!