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

setting column width 1
change zoom based on column width 2
How to replace full-width characters and numbers with half-width ones? 2
Column Width Template Question 3
Changing fixed width (column break) defaults when importing text 1
how to use 'match half/full width forms' ??? 1
How to find data character width in Excel 2
How do I get more than 255 characters into a cell? 3

Top