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

 

[Ali M]

does it work for the table ? because my data in Table.
doesn't seem running the code when press f5.

 

[MARK858]

doesn't seem running the code when press f5.

You won't see it run, have the formulas changed?

 

[Ali M]

in column G,H as I did it in post#19 doesn't change anything .

 

[MARK858]

Try the code below but definitely on a copy of your workbook

Sub UniKiller()
' amended code originally by Gary's Student
    Dim s As String, temp As String, i As Long, x As Long
    Dim C As String
   
    For x = 1 To Cells(Rows.Count, "A").End(xlUp).Row
    s = Cells(x, 1).Value
   
    temp = ""

    For i = 1 To Len(s)
        C = Mid(s, i, 1)
        If AscW(C) > 31 And AscW(C) < 127 Then
            temp = temp & C
        End If
    Next i
    Cells(x, 1).Value = temp
    Next x
End Sub

 

[Ali M]

ok it works just for the column A but should be up to column F .
and there is problem will clear the word for header in A1 shouldn't do that . just delete unwanted symbols .
thanks again

 

[MARK858]

and there is problem will clear the word for header in A1

What exactly is in the header as letters and numbers should have remained? and the same question for the other columns

 

[Ali M]

in A1= "BALANCE" but after delete non printable character will also clear BALANCE . should not do that
the columns in TABLE A,B,C,D,E,F all of the headers are letters .

 

[MARK858]

It doesn't clear the word BALANCE for me, is it in English?

 

[Ali M]

sorry by Arabic will be "الرصيد"

 

[MARK858]

Are there Arabic characters in the main body of columns A:F?