Is there a formula that removes second identical sentence on a text.

Occasional Contributor

In this file as you can see, there are two same sentences, I need to remove the 2nd identical sentence.

Problem here 

7 Replies


Could you please attach the file to the post

Yes @Sergei Baklan now you can check it.





You can use below formula in cell B2 and drag it down.





Hope this helps.





Ignore the posting. It's a scam. The moderators have been notified.