0

I have text content in google sheets cell like this:
Desciption :



RGB (red, green, blue) colored LED lighting bulb - 16 colors total. Can be used in a single static (fixed) color or simply press the remote control to produce one of four color changing effects.
Great for retrofitting into existing track lights or downlights, make your interior decorations and space shine with this one of a kind LED color changing RGB lighting bulb.


Low wattage; save energy, the environment, and also save money on electric bill.

Fixed colors include four primaries; White, Red, Green, Blue, and 12 bright color hues.




This amazing LED light bulb is capable of emitting White, Red, Green, Blue, plus twelve additional bright colors. In addition to the brilliant colors you can produce with this light bulb, you have the added benefit of reducing your energy costs since only uses 3 watts of energy.




Great for retrofitting into existing track lights or downlights, make your interior decorations and space shine with this one of a kind LED color changing RGB lighting bulb.

Low wattage; save energy, the environment, and also save money on electric bill.

====================

Is it Possible to solve this with formula or script ?

1. I need only to remove duplicate sentence not word

yes i know there are some repeatative word like LED, color, bulb, in this case i want to remove 2 duplicate sentence:

Great for retrofitting into existing track lights or downlights, make your interior decorations and space shine with this one of a kind LED color changing RGB lighting bulb.

Low wattage; save energy, the environment, and also save money on electric bill.

2.Also How to Remove Empty Line that more than 2 or 3 appear before sentence like paragraph above

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.