How to generate product descriptions?

Question

excel

I fill in quite a lot of goods, I don’t plan a unique description of each yet.
There is a desire to generate a description for each product from the characteristics.
Example:
(Product type) (Article) (Manufacturer) is made in style (Style), intended for use in (destination), etc.
Do you have any ideas how to organize the process?

Answer 1

For products, create an Excel table with fields (example, column headings):
A - (Type of product)
B - (Article)
C - (Manufacturer)
D - (Style)
E - (destination)
F - (description)
In the column description formula (example for cell F2)
=A2&" "&B2&" "&C2&" is in the style of "&D2&", intended for use in "&E2 and so on. following logic.
A similar option through the CONCATENATE formula:
=CONCATENATE(A2;" ";B2;" ";C2;" is made in the style of ";D2;", intended for use in ";E2) , etc. Don't forget that both options concatenate the value character by character, After stretching the formula, get a column with a description.
And then drag from the column wherever you like.

Answer 2

https://codepen.io/forgetable/pen/ybEyXr