Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,358
Default Special Characters causing problems

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Watermark Causing Print Problems kbellando Excel Discussion (Misc queries) 0 March 15th 08 02:12 AM
User Defined Function Causing Problems Steve Excel Discussion (Misc queries) 11 December 21st 06 01:18 PM
my personal.xls file is causing problems Chrisinct Excel Discussion (Misc queries) 3 December 7th 06 04:28 PM
Rand () causing Problems. JCary Excel Discussion (Misc queries) 1 March 6th 06 11:38 PM
Is Excel causing me system problems? Sandra Excel Discussion (Misc queries) 1 April 7th 05 10:04 PM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"