+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Creating combinations of words

  1. #1
    Registered User
    Join Date
    12-02-2009
    Location
    Madison, WI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating combinations of words

    Hi, I'm trying to create an easy-to-use spreadsheet to create all possible combinations of words, for Google Adwords. For example, I might have combinations up to 6 words, for example:

    Nike
    Jordan
    Red
    Basketball
    Shoes
    Cheap

    I'd like it to automatically create all possible combinations like:

    Nike Jordan Red Basketball Shoes
    Jordan Basketball Shoes
    Shoes Cheap
    Red Basketball Shoes Cheap
    Nike
    Red Basketball
    Nike Jordan Shoes Cheap

    The strings can be 1 word through 6 words, and ideally, I'd like to have this work so that if I replace "Nike" with "Reebok", the list of combinations will automatically reflect that change.

    Any suggestions for how to accomplish this?

    Thanks!

    Scott

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Creating combinations of words

    You may find some inspiration here.

    http://www.excelforum.com/excel-prog...binations.html
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1