Forum Discussion
maverickfp18
Jan 21, 2025Copper Contributor
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 hundred rows of data so wanting to see if there's a quicker way to clean it. The top line of my picture is how I want it to look (I deleted the extra data manually).
Thanks for any help!
- OliverScheurichGold Contributor
=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.
- maverickfp18Copper Contributor
This is great. Thanks!
- maverickfp18Copper Contributor
Thank you! Worked like a charm! Any ideas on how to delete the rest of that data that ISN'T mesh?