I have been able to insert the Thai Baht currency sign using the formula (Range("A1").Value = ChrW(&HE3F) & "123". My problem is that I would like to automate the REMOVAL of the Baht sign from spreadsheets sent from Thailand. I need to do this because I own a restaurant there. I get daily sales and expense reports, but I can't consolidate those worksheets to get weekly, monthly and annual numbers unless I remove the Baht sign because Excel does not recognize it. I can remove it manually from each individual worksheet by copying the Baht sign from the worksheet and removing it using "Find and Replace" but I would like to automate the technique, if possible, to save myself some time. Unfortunately, the macro doesn't work because VBA doesn't recognize the character, and trying to replace it in the code doesn't work either. (It replaces the Baht sign with a "?" and so the code won't run). I have tried to use the unicode for the Baht but that too doesn't work. Can someone suggest a method for removing the Baht sign from the spreadsheets with a macro or some VBA code? Is it even possible? I would appreciate any ideas.