Unique Words
 

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?

Hi

you might be getting some leading or trailing spaces in your words ... try
in another column the formula
=TRIM(A1)
where A1 is your first piece of text
and copy down the length of the text, now copy & edit / paste special -
values this column back over the original (and delete this column) and then
try the unique filter.

Cheers
JulieD

"Travis" wrote in message
...
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?