Labialized characters

[ollyhughes1982]

Hi,

I have a list of characters in excel and it includes the Labialized character 'ʷ'. I am doing a remove duplicates in Excel and it is picking this up as a duplicate of a normal 'W' or 'w', which are also in my list. Is there a way to stop this happening, as they are not the same. I need to get to a unique list of values and removing duplicates removes this character.

Thanks in advance,

Olly.

 

[hagia_sofia]

Maybe you could use CODE function to your advantage as CODE("W") = 87, CODE("w") = 119 and CODE("ʷ") = 63?

 

[ollyhughes1982]

Maybe you could use CODE function to your advantage as CODE("W") = 87, CODE("w") = 119 and CODE("ʷ") = 63?

Ah, I see, add a helper column and de-duplicate on the helper column instead? I wasn't aware of the CODE function until now. Thanks. You can see on my Mac version it is indeed picking up the different codes.

 

[hagia_sofia]

Ah, I see, add a helper column and de-duplicate on the helper column instead?

Indeed. And sorry I did not notice you are on Mac.