japanese

  1. C

    Split kanjis, words, phrases into different cells to make a Japanese vocabulary list

    Hi, I am trying to (1) separate a list of kanjis, Japanese words, Japanese phrases into a column list (2) add a separate column the hiragana (3) add a separate column for the English meaning so the list would be something like this Challenge: some times there would be some words that...
  2. A

    Retrieve data from Oracle DB using VBA Excel containing Japanese Character

    I am trying to fetch data from my oracle db using excel VBA. I have made the connection and successfully fetching the data, however my data containing japanese character is broken. It became something like "A14 ソソ: ソソソ ソ ソソ: ソソソソ (ソソソソソ)" I wonder why my data containing japanese character is...
  3. tvsramesha

    Removing Japanese characters from workbook

    Hi All - Thanks in advance, I'm using OCR conversion and importing into excel, the label from contains Japanese characters apart from alphanumeric(western) characters, want to only clean the Japanese characters, please help me with a macro to remove the Japanese characters(copied below) Ramesha...
  4. L

    Katakana to hiragana VBA

    Hi all! I have an excel file where I have to change Katakana characters to Hiragana. I've been using StrConv + vbHiragana for some time, however, it is really slow since I am using it in a range for a 1000 rows (two times). After searching around, I've found the following code, which seems like...
  5. S

    Formula Incompatibilities Between US and Japanese Versions of Excel

    I'm responsible for creating a number of Excel-based tools for use by co-workers, most of whom are based in the US. There's one in Japan, however, who periodically experiences tool problems because of differences between the US and Japanese versions of Excel. Most recently, there was a formula...
  6. J

    The phonetic() function

    Hi, I'm not sure if anybody has ever heard of this function, but according to Microsoft: http://office.microsoft.com/en-us/excel/HP052508411033.aspx Well...I've tried these examples in my version of Excel 2007 but they return N/A errors. In fact, these formulas don't work for any other Kanjis...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top