View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
talkswithnumber[_3_] talkswithnumber[_3_] is offline
external usenet poster
 
Posts: 1
Default What is this Strange Characet? Find/Replace


There are a couple of ways you could try to figure this out. The squar
character shows up when the character's number doesn't have
corresponding symbol (like a letter) defined in the font. Maybe yo
could try a couple of other fonts in your text editor to see if i
changes into something that you can then figure out. Another option i
to run your file through a little vb code that checks what the cha
number is at the position that this character appears in your file:

'myString has the text, and the character is at position 10
debug.print asc(mid(myString,10,1))

or something like that...

--
talkswithnumbe
-----------------------------------------------------------------------
talkswithnumber's Profile: http://www.excelforum.com/member.php...fo&userid=1684
View this thread: http://www.excelforum.com/showthread.php?threadid=32030