Rename brand campaigns using REGEXREPLACE()

Campaign names are never set in stone. In this case, your marketing director has informed you of a naming convention change to help comply with the naming conventions of the social media marketing team. In order to comply with the naming conventions, all 'Brand' words need to be changed to 'Branded'.

In this exercise, you will use an IF() statement with REGEXMATCH() to find the branded campaigns, then replace the word Brand with Branded using REGEXREPLACE().

Recall that with REGEXMATCH(), you first supply the test cell, and then you supply the regex pattern.
With REGEXREPLACE() you supply the text (in this case the cell), your regex pattern, and the new string you want to swap in.

A pattern to match branded campaigns is already written for you in cell I2.

Este exercício faz parte do curso

Marketing Analytics in Google Sheets

Ver curso

Instruções do exercício

In cell F2, add an IF() statement:
- As your first argument, test if cell B2 contains the pattern in $I$2 using REGEXMATCH().
- As your second argument (if the match is TRUE), use REGEXREPLACE() to replace then contents of B2 which matches $I$2 with "Branded",
- Lastly, as your third argument (if the match is FALSE) return the tested cell B2.
Apply the formula to the remainder of the cells, F3:F29.
As a starting point, your formula should be structured like this: IF(REGEXMATCH(___,___), REGEXREPLACE(___,___,___), ___)

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício