Keyword Permutations

[gimmeexcel]

I'm not sure if this is possible, but...

I'm trying to create all possible permutations for a string of keywords in a ell.

For instance, Cell A1 contains: Black Air Max M200 Super Light Basketball Shoe

So that's 8 words, and I need all possible 2, 3, 4, 5, 6, 7, and 8 word combinations in EVERY possible word order.

Is it possible to do this? And what would it take to accomplish this in the most efficient manner, perhaps a built-in function?

Many thanks in advance!

 

[gimmeexcel]

Thanks SHG! That macro works really well.

Many thanks for your help!