Concvert Full Width Katakana characters into Half Width Katakana C

Mandeep Dhami

Guest

Posts: n/a

30th Nov 2007

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

« Excel and Flash | Temporary Internet Files »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to use 'match half/full width forms' ???	golakers	Microsoft Word Document Management	1	24th Feb 2009 01:43 AM
Concvert Full Width Katakana characters into Half Width Katakana C	Mandeep Dhami	Microsoft Excel Misc	0	30th Nov 2007 06:47 AM
ASC() does not convert full-width to half-width letters (Exel 2003	=?Utf-8?B?RFk=?=	Microsoft Excel Worksheet Functions	0	27th Jan 2007 01:34 PM
How to replace full-width characters and numbers with half-width ones?	iherage@gmail.com	Microsoft Word Document Management	2	15th Aug 2006 11:52 PM
how to control string length for full-width and half-width characters	Russell	Microsoft Dot NET	0	4th Jun 2004 05:20 AM