Working with MS Excel 07 and VB.
In the attached workbook I have populated column A with a list of names I've retrieved from a gaming forum i use. The simplified Chinese symbols you see beside each name represent different achievements those players have achieved. There is a total of two symbols used. Below are the symbols and their Unicodes.
1. 庙 (U+5E99)
2. 畜 (U+755C)
Some cells have both symbols while others have just one. Where symbol pairs occur, I cannot guarantee they're always in the same order.
I want to remove these symbols from all occupied cells in column A so i can use each cell's value for further procedures without problems.
I've seen other people use the "regular expression" function to eliminate or replace characters or specified strings with success. Also from what I've read it looks like the only way to do this properly is with use of the Unicodes I've provided.
I'd appreciate it if someone could help me write some code to do this.