Keyword Generation: Concatenation and Substitution
Discover the easiest ways to generate keywords in bulk using Excel. These formulas are the basis of so much work, and keyword generation really will just give you a top-level understanding of the formula's use.
Concatenate - Join as many cells together as needed
=CONCATENATE(*First CELL to join*,*Second CELL to Join*)
& - The better way of joining items together
=*CELL to Join*&*CELL to Join*&"Some text to join on the end"
Substitute - Swap text in a cell, for other text
=SUBSTITUTE(*CELL for text swap / the template*,*Old text for replacing*,*New text to replace with*)
Great stuff..
Thanks Jerry! I am glad you like the video 🙂