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

[Edo]

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

Problem here 

[#2]

@Edo 

Could you please attach the file to the post

[#3]

Yes @Sergei Baklan now you can check it.

[#4]

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

[#5]

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

[#6]

You are scammer @BryanLewis42 

[#7]

Thanks it worked.

[#8]

You are welcome!