Spreadsheet: 149291d1333813435-remove-duplicate-words-from-2-cells-when-2nd-cell-has-a-sentance-exampledata
Sheet: Sheet1

Manufacturer | Product Name | Short Description | Description <description> (admin)
Conair Professional | Conair Pro Dual Professional Straightening Pic | The Conair Pro Styling Pic attachment contains special "fingers" that are ideal for lifting hair from scalp helping to straighten unwanted curl and frizz. | Conair Pro Dual Professional Straightening Pic Universal fit, Vented barrel [NAME], Perfect for straightening naturally curly or wavy hair, Will not damage or break hairThe Conair Pro Styling Pic features a universal fit that easily slides onto the dryer barrel to create smooth and straight hair quickly while blow drying. Great for straightening naturally curly or wavy hair.  Shop beautysupplymiami.com
Conair Professional | Conair Pro Black Appliance Holder | Maximize your work space with this electrifed appliance center from Conair Pro that mounts to any wall, table or counter. | Conair Pro Black Appliance Holder Triple outlet with ALCI safety plug, Durable steel construction, Black powder coated finishThe Conair Pro Appliance holder turns any table, counter or wall into an electrified appliance center that allows you to maximize your work space. Constructed of high quality steel with a black powder coated finish that looks great in any salon. Holds a hair dryer, 2 curling irons (up to 1 1/2" barrel) and 1 flat iron (up to 2" plates).  [NAME] with triple outlet with an ALCI safety plug.  Shop beautysupplymiami.com
Conair Professional | Conair Pro Electrified Appliance Holder | The Conair Pro Appliance Holder lets you maximize your work space by turn any styling station or table into a complete electrified appliance center! | Conair Pro Electrified Appliance Holder Electrified appliance center, Triple outlet with ALCI safety plug, High quality chrome finishNow turn any table or station into a complete electrified appliance center with a Conair Pro Appliance Holder Stand. Maximize your work space by mounting this high quality appliance holder stand to any table or counter. Durable chrome finish fits any salon decor. Holds a hair dryer, a flat iron up to 2" plates and 2 curling irons up to 1 1/2"barrels. Complete with triple outlet that features a ALCI safety plug.  Shop beautysupplymiami.com
Conair Professional | Babyliss Scalp Massage Brush | The Babyliss Scalp Massage Brush gently massages hair and scalp. Stimulates the hair follicle for healthier hair. | Babyliss Scalp Massage Brush Thick bristles gently massage and stimulate the scalp for healthy, shiny hair, Non slip handle is contoured to fit in the palm of the hand for extra comfort and control, [NAME] styling products evenly throughout hairThe Babyliss Scalp Massaging Brush has a unique contoured shape that conforms to the palm of your hand, allowing your hand to naturally cup the brush.  The thick bristles massage the scalp while stimulating the hair follicle for healthy, shiny hair.  The shape and style of the brush along with the bristles help to evenly distribute styling products.  Shop beautysupplymiami.com
Conair Professional | Jilbere Baby Bristle Brush | The Jilbere [NAME] is a small-sized gentle bristle brush designed specifically for babies. | Jilbere Baby Bristle Brush Extra gentle for babies, Smoohtes fine baby hair, [NAME] bristles will not scratch delicate baby scalp, Perfect size for little heads, Assorted colorsExtra gentle and soft bristles smooth hair without scratching delicate baby scalps. Distributes the natural oils from their origin in the scalp to the hair ends. Handle designed to comfortably fit any hand. Makes the perfect gift for the mother to be.  Shop beautysupplymiami.com
Clean + Easy | clean + easy Bare-zilian Hard Wax | clean & easy Bare-Zilian Hard Wax effortlessly adheres to the hair, not the skin, for sensuously soft results. | clean + easy Bare-zilian Hard Wax Removes all types of hair from fine to coarse, Designed for sensitive and delicate areas, Strip, Free Formulaclean + easy, the recognized leader in beautiful, hair free skin, introduces [NAME] zilian a high quality experience to waxing. This wax leaves skins soft and smooth with no wax residue. Recommended for male and female Brazilian waxing.   Being hair free has never been so easy.  Shop beautysupplymiami.com
Clean + Easy | clean + easy Tweeze Free Microwave Hair Remover | clean + easy Tweeze Free Microwave Hair Remover is for coarse hair, no strips needed. Quick, easy and gentle. | clean + easy Tweeze Free Microwave Hair Remover Quick, safe and easy way to remove unwanted hair, No need for the use of muslin strips, [NAME] away coarse hair instantly, Made with azuleneClean + easy Tweeze Free Microwave Hair Remover is designed for waxing sensitive skin areas quickly and easily without the use of muslin strips. Waxes away coarse hair instantly.  Shop beautysupplymiami.com
Desired Format
Manufacturer | Product Name | Short Description | Description <description> (admin)
Conair Professional | Conair Professional Jilbere Baby Bristle Brush | Conair Professional Jilbere Baby Bristle Brush is a small-sized gentle bristle brush designed specifically for babies. | Conair Professional Jilbere Baby Bristle Brush Extra gentle for babies, Smoohtes fine baby hair, [NAME] bristles will not scratch delicate baby scalp, Perfect size for little heads, Assorted colorsExtra gentle and soft bristles smooth hair without scratching delicate baby scalps. Distributes the natural oils from their origin in the scalp to the hair ends. Handle designed to comfortably fit any hand. Makes the perfect gift for the mother to be.  Shop beautysupplymiami.com
Note:
I have 3500 records some are formated correct and others aren't.  My approach is to remove "manufacture" (A) from "product [NAME]) then add it back, thereby assuring (B) is complete.  Then Remove (B) from (c ) then add it back
Then Remove(C ) from (D) and then add it back.  Thereby assuring that my final product has the product manufacture and product name in my short description and description.
Notice how in 7B clean + easy is not cap.  Then in C7 clean "&" easy instead of the "+" I will need to fix this type of error also.
There may be a better way to accomplish this task??  Possibly an if/ then statement, patern matching, or something along these lines.