Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
JIS / ASC Functions in Excel 2007
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
JIS / ASC Functions in Excel 2007
They are there, according to:
http://office.microsoft.com/en-us/ex...645341033.aspx Don't have that version installed, so can't confirm. If they really are missing, you could write your own function based on StrConv. NickHK "JC3" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
JIS / ASC Functions in Excel 2007
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... "NickHK" wrote: They are there, according to: http://office.microsoft.com/en-us/ex...645341033.aspx Don't have that version installed, so can't confirm. If they really are missing, you could write your own function based on StrConv. NickHK "JC3" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
JIS / ASC Functions in Excel 2007
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 "JC3" wrote in message ... 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... "NickHK" wrote: They are there, according to: http://office.microsoft.com/en-us/ex...645341033.aspx Don't have that version installed, so can't confirm. If they really are missing, you could write your own function based on StrConv. NickHK "JC3" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 labels in functions no longer supported! | Excel Worksheet Functions | |||
CUBE Functions in Excel 2007 | Excel Worksheet Functions | |||
2007 Excel Functions | Excel Discussion (Misc queries) | |||
2007 Excel Functions | Excel Worksheet Functions | |||
Excel 2007 Beta - help no longer functions | Excel Discussion (Misc queries) |