Macro to output all possible inverted phrases

[DannyTEM]

If I have a column containing search keyphrases, is it possible using a VB macro to output all possible inverted 2 keyword phrases if they do not already exist?

For example:

keywork 1 keyword 2

Would be converted to keyword 2 keyword 1 if the inverted phrase did not exist already in the column.

Conversely, keyword 1 keyword 2 keyword 3 would not be processes as it is a 3 keyword phrase.

Thanks,

Dan

Dan Morgan -

http://www.ski-review.com

 

[stevexff]

Yes, it probably would. But what purpose would it serve? There may be a better way to do what you are trying to achieve...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[DannyTEM]

Thanks for your reply.

It is essentially a taxonomy project, I have a list of key phrases and the application requires that all 2 word keyphrases are also present in the column reversed or inverted.

Cheers,

Dan

Dan Morgan -

http://www.ski-review.com