Hi everybody! So for a project I need to put together a list of Portuguese-speaking last names. So I have various sources where I copied from, so I have one column in excel where I put all that data. I sorted the data to be in the correct alphabetical order. But when I try to remove the duplicate values in that column is says it removed them but it didn't and when it does it leaves many behind. I have tried the trim function, and even formatting but nothing works. If someone could explain to me what the problem is it would be much appreciated! I attached the non-formatted and non-trimmed list, because it doesn't seem to be making a difference.
Thank you,
Tim
Bookmarks