unanble to replace wierd symbols from a text file

[Brucea]

I am brining in data to excel from a text file. I have no control over the contents of the text files since it comes from many different sources. I am getting the symbols below. They are suposed to be Feet ' and Inches" but are coming through as shown below.
SERENGETI 13╞2÷ö
╞
I put in a find and replace routine which replaces all of them fine except the ╞ symbol. when I try to paste it into my code, it turns into a question mark. Is there some other way to change or eliminate these symbols without going back to the text file?
Thanks in advance for any help!!

 

[texasalynn]

try this

Sub ctrim()
Range("E1:E200").Replace What:=Chr(63), Replacement:="Ft", LookAt:=xlPart
End Sub

change range to match your data

 

[Brucea]

Thanks, I will give that a try. Is there a place where can I find a chart/list showing all of the characters and symbols?
Thanks again for the help.

 

[texasalynn]

If you installed all of the systems tools with your operating system, there is a character map program. Otherwise you could google and I'm sure you would find something. :wink: