Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, assuming you have the data in a cell, you could use CODE and MID to
find out the CHAR specified.... For example, say I wanted to find the code of the character where the # is in the following phrase: The quick re# fox jumped over the lazy brown dog. =CODE(MID(A1,13,1)) -- ** John C ** "Vickie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Watermark Causing Print Problems | Excel Discussion (Misc queries) | |||
User Defined Function Causing Problems | Excel Discussion (Misc queries) | |||
my personal.xls file is causing problems | Excel Discussion (Misc queries) | |||
Rand () causing Problems. | Excel Discussion (Misc queries) | |||
Is Excel causing me system problems? | Excel Discussion (Misc queries) |