Problems with languages in VBA

[Ulisses_Carso]

Good afternoon everyone, I have a serious problem, I'm doing data processing and I came across a character in Hebrew, the problem is that VBA doesn't recognize the character because it doesn't support the language, and I need to delete it and I have no idea how

the field in question is: נהג 36448734

I only need to eliminate this symbol, I've tried several ways with Replace but without success, can you help me?

 

[alansidman]

Use the excel translator and see if that will change the language so you can remove/replace.

Translate text into a different language - Microsoft Support

Translate all or part of your document into another language.

support.microsoft.com

In your case the letters are Nun, Hay and Gimmel and translate to Driver.

 

[MARK858]

Try the code below on a copy of your worksheet

Sub Removesymbol()
ActiveSheet.UsedRange.Replace What:=ChrW(1504), Replacement:="", LookAt:=xlPart
ActiveSheet.UsedRange.Replace What:=ChrW(1492), Replacement:="", LookAt:=xlPart
ActiveSheet.UsedRange.Replace What:=ChrW(1490), Replacement:="", LookAt:=xlPart
End Sub

 

[Ulisses_Carso]

Try the code below on a copy of your worksheet

Sub Removesymbol()
ActiveSheet.UsedRange.Replace What:=ChrW(1504), Replacement:="", LookAt:=xlPart
ActiveSheet.UsedRange.Replace What:=ChrW(1492), Replacement:="", LookAt:=xlPart
ActiveSheet.UsedRange.Replace What:=ChrW(1490), Replacement:="", LookAt:=xlPart
End Sub

Thank you mate, you solved my problem masterfully!!!

 

[MARK858]

You're welcome, happy we could help