how clean strange symbols(?þ) from Table or range

[Ali M]

Hi experts
I face dilemma when I received file by another person .
it shows after name like this :

item?þ
itemþ?
so how can I delete these from all of my table or in used range to become like this
item
is there any macro to clean the cells in table or in used range?
this symbols cause me big troubles with another macros(can't run)
thanks

 

[MARK858]

I don't see how, that line only removes one character

 

[Ali M]

I will check again .

 

[MARK858]

If it does then it means that your Hebrew characters are created using the ? character and if that is the case we might be stuffed unless there are only Hebrew characters in row 1.

 

[Ali M]

is this right ?

Sub Remove8207()
    With ActiveSheet.UsedRange
        .Replace What:="~?", Replacement:="", LookAt:=xlPart
        .Replace What:=Chr(63), Replacement:="", LookAt:=xlPart
    End With
End Sub

if it's so the problem is still clearing

it means that your Hebrew characters are created using the ?

Arabic , not Hebrew !

 

[MARK858]

Arabic , not Hebrew !

Sorry.

 

[MARK858]

is this right ?

Sub Remove8207()
    With ActiveSheet.UsedRange
        .Replace What:="~?", Replacement:="", LookAt:=xlPart
        .Replace What:=Chr(63), Replacement:="", LookAt:=xlPart
    End With
End Sub

I meant changing it in the code in post number 35 not post number 34

 

[Ali M]

the same problem !

 

[MARK858]

the same problem !

Then your characters might be made up using the ?
Can you just try

ActiveSheet.UsedRange.Replace What:="~" & Chr(63), Replacement:="", LookAt:=xlPart

 

[Ali M]

the symbol ? is still existed

 

[MARK858]

Last attempt, try the lines below separately

ActiveSheet.UsedRange.Replace What:="~" & ChrW(8236), Replacement:="", LookAt:=xlPart

ActiveSheet.UsedRange.Replace What:=ChrW(8236), Replacement:="", LookAt:=xlPart