How to Extract Single Words from Excel Column

[Mediadirect1]

Hi,

Can you share with me a program that can extract all single words (preferably unique) from a spreadsheet/column? I have a column which contains rows with many words in each.

I prefer to extract all words in all lines rather than just first or last word.

If you have a macro, kindly also give steps as to how to install it, because I have never installed a macro. Alternatively, you can send me an excel attachment with macro enabled.

Thanks.

MD

[shg]

Select the column, do Data > Text to columns, tick Delimited, Next, tick Space, Finish.