I am copying and pasting numbers and text from 2 seperate programs. The 1st
program has numbers in front of the text. I remove the numbers by doing a
text column and then deleting the number column. With the text that remains
in the next column I then move it over to column A.

Then I grab my next set of text from the 2nd program and copy and paste it
afterthe last word in column A. I then do an A-Z sort to list them
alphabetically.

I then name the top row "NAME" and try to do a filter to take out the
duplicate names by doing a unique filter on that column. However, all
duplicate words remain. I have been able to do this 2times with success but
seem to be missing a step or doing steps in the wrong order. Any help?