Hi All,
I have thousands of cells containing text. Some of those cell have a common thread...Person 2 stated:
I would like to delete that phrase and any other text that follows.
Thanks for any help you can provide.
Jorge
Hi All,
I have thousands of cells containing text. Some of those cell have a common thread...Person 2 stated:
I would like to delete that phrase and any other text that follows.
Thanks for any help you can provide.
Jorge
You didn't attach an example, so we can pretend you data is in Column A.
Then in B1:
=IF(ISNUMBER(SEARCH("Person 2 stated:",A1)),MID(A1,1,SEARCH("Person 2 stated:",A1)-1),A1)
and copy downwards
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Or maybe this one
=IFERROR(TRIM(REPLACE(A1,SEARCH("Person",A1),LEN(A1),"")),A1)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you very much daffodil11, solved my issue 100%.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks