Hi folks, looking for code to put in a column of cells, say C1:C100 that looks at the words put in column A1:A100, and it will only show one word if there are many. For example, the first 10 are a mixture of 5 words each of say blue and green. Column C will only show one word each of blue and green. Any help will be much appreciated. Thanks.