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*)

 

2 Comments

  1. Great stuff..

    Reply
    • Thanks Jerry! I am glad you like the video 🙂

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.
Download the Google Analytics Dashboard
  You will receive a download link via email. We hate spam and never share your details.
Download the Excel Reporting Templates
  You will receive a download link via email. We hate spam and never share your details.