How to automate text replacement for meta-titles and meta descriptions for webpages?

[MisleadJohnny]

Hi, I'm trying to figure out how to automate a process of filling in some holes inside a predefined phrase or structure to write meta titles and meta descriptions. Here's an example down below. So I have plenty of columns with text that I'd like to use to fill in blanks and since I have thousands of rows to do I'd like to be able to find a way to automate the process. Any ideas how?

Category pages: $categoryName | $shopName – so for example: “T-shirts for men | Joe’s T-shirts”.

Subcategory pages: $subcategoryName | $categoryName | $shopName – so for example: “Breaking Bad T-shirts | T-shirts for men | Joe’s T-shirts”.

Product detail pages: Buy $productName | $subcategoryName | $shopName – so for example: “Buy Mr. White T-shirt | Breaking Bad t-shirts | Joe’s T-shirts”. Here we’re deliberately leaving out $categoryName, as that would often make the title too long.

Here are sample meta description:

Category pages: Looking for $categoryName? Check out our massive selection of $amountOfProducts T-shirts at $shopName!, so for example: “Looking for T-shirts? Check out our massive selection of 10,431 T-shirts at Joe’s T-shirts”.

Subcategory pages: use the same template as mentioned above for category pages.

Product detail pages: Buy a $productName starting from $productPrize. Shipping time: $shippingTime. Only at $shopName!, so for example: “Buy a Mr. White T-shirt for as little as $19.99. Shipping time: 24 hours. Only at Joe’s T-shirts!”.

Thanks in advance!

Here's the screenshot of the page, i'm trying to fill in the column CK.

Screen Shot 2020-05-27 at 11.59.48 AM.png

[Limor_OP]

Maybe a drop down list?

If you upload a sample file - it would be easier to understand how your file looks like, and to try and help you out.

[MisleadJohnny]

Added screenshot, thanks for the reply by the way

[Limor_OP]

Thanks, but it would be better in excel.

Also - how do you get to the combination of words? where is it taken from in your sample? Does the info. come from Hidden columns?