JIS / ASC Functions in Excel 2007

J

JC3

I have several text strings in single-byte Japanese I need to convert to
double-byte Japanese. The JIS and ASC functions in Excel are listed in Excel
Help, but they are not available in Excel 2007. Attempted use generates a
NAME? error. I am running English Vista, and I have Japanese fonts installed
in both Vista and Office 2007. How do I get the JIS & ASC functions to load
/ install / work?
 
J

JC3

The functions really are missing in both Office 2007 and Office 2003 in the
English versions, even though Japanese fonts and support are installed.
Working for a Japanese company, use of these functions would be quite
helpful...
 
N

NickHK

Can't say I use either function, but ASC is in XL2002, but JIS returns
"#NAME?"

Help on JIS says:
"The name of the function (and the characters that it converts) depends upon
your language settings."

Wheter that means the function may actually be called something else, I'm
not sure ??

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top