Basically what I need is a formula and a formula within a formula, if that’s possible, that will create the descriptions from the sentences that I created. See the attached spreadsheet. Do I need to set it up differently and how do I set up the formula to do this? Title_Description_Details 10-16.xlsx
For example,
The title of the product is Diamond Bridal Rings 14K White Gold Princess Solitaire with Side Stones Set (1.01 ct.tw.)
I have written sentences for Diamond, Bridal set, 14k White Gold, Princess, Solitaire. I need to take each of those sentences, plus the title and put them together to write a description. I also would like to have it fill in the gold weight and color and the diamond carat weight and color and clarity where appropriate.
So the description for this one would read:
Diamond Bridal Rings 14K White Gold Princess Solitaire with Side Stones Set (1.01 ct.tw.) Beautiful coordinating engagement ring and wedding band set in 14k white gold is the perfect symbol of love for your special day and forever. A simple, classic, light gold color, 14k white gold is a rare gold valued for its lustrous shine. The brilliant diamonds are a beautiful (XX) color and (XXX) clarity.
The Princess cut is a modern, square or rectangle cut increasing in popularity and known for its brilliance. The Solitaire is the most popular diamond ring setting because of its simplicity and its classic design featuring a single center stone. This ring features a (0.xxx) carat center stone with a total carat weight of 1.01 ct.tw.
Bookmarks