Phrase is repeated within a cell - how do I remove ONLY the second instance and keep the first?

خرید بک لینک

I have a column that has a repeated phrase in it. Example:

Cell A2:

Weather Report. Clouds: Gray; Rain: Light; Clouds: Gray; Temperature: Hot

Cell A3:

Weather Report. Tuesday. Clouds: Gray; Rain: Heavy; Pollution: Bad; Clouds: Gray; Bananas: Yellow

The Phrase "Clouds: Gray;" repeats. I want to make it so that the second instance of the phrase is removed from the cell, but the first one remains. The end result should look like this:

Cell A2:

Weather Report. Clouds: Gray; Rain: Light; Temperature: Hot

Cell A3:

Weather Report. Tuesday. Clouds: Gray; Rain: Heavy; Pollution: Bad; Bananas: Yellow

Since there's no consistency in the cell aside from this one repeated phrase, I have no clue where to begin. Any help would be greatly appreciated!

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 277 تاريخ: چهارشنبه 30 تير 1395 ساعت: 21:09

صفحه بندی