Concvert Full Width Katakana characters into Half Width Katakana C

M

Mandeep Dhami

Hello,

I have a database of Japanese Names in Excel which are in Full Width
Katakana Characters. I need to convert them all into Half Width Katakana
Characters.

I can do that, but its all manual. I need to select each word in a line and
then convert it to Half Width Character. There could be many words in a line.
I have got to convert close to 20,000 lines. This will involve huge time.

Is there any way in which I can do that quickly through some formula or
macro??

Cheers,
Mandeep
 

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

Similar Threads

Help With Typing Russian Letters On Microsoft Word Mac 0
Two columns followed by single page-width column on same page 0
Table Preferred width is changed when pasting 1
Narrow Paragraphs to Wide Paragraphs 1
Converting URLs in comments to Markdown-formatted links 2
Move Chart with Text 0
ASC() does not convert full-width to half-width letters (Exel 2003 0
change zoom based on column width 2

Top