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

@Edo 

Could you please attach the file to the post

Yes @Sergei Baklan now you can check it.

Untitled.png

 

Hi,

 

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

 

=IFERROR(MID(A2,1,LEN(TRIM(A2))/2-1),"")

 

 

Hope this helps.

 

 

Regards,

IlirU

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