View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vickie Vickie is offline
external usenet poster
 
Posts: 5
Default Special Characters causing problems

I get a report monthly from our office in Japan. They use some ï¼*ï¼³ Pゴシック
character font that I don't recognize. When I change the formatting, all
shows up okay except there are a few characters that appear to be okay, but
are slightly different. These are random "(" and ")" and even some letters
like M or F or H. I tried to write a search and replace macro but it is not
picking up the characters properly. I would put in their CHR() properties,
but don't even know how to find out what they are. Help!! These characters
are really wreaking havoc in our DB2 database where we upload the information.