Concvert Full Width Katakana characters into Half Width Katakana C
 

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