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