Remove Thai Baht (Currrency) Sign

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.

Are you receiving these file from Thailand with Baht sign and want to remove the Baht sign?

Can you post a sample file of what you are receiving and we can take a look at it?

This is not ideal, but a start.

If you have the symbol say in cell A2. You can check the worksheet to that cell and replace

Again, a sample file would be very helpful. You can modify the below to loop the worksheets as well.

Sub remove()
    Dim r As Range
    Dim stringvalue As String


    stringvalue = Range("A2").Value
    
    For Each r In ActiveSheet.UsedRange
       r.Value = Replace(r.Value, stringvalue, "")
    Next r
       
End Sub

Please see the response from ByteMarks below. It works perfectly.

Thanks for your interest!

This works for me.

Sub Replace()
Cells.Replace ChrW(&HE3F), "", xlPart
End Sub

It works perfectly. Thanks a million!