Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly 
when this is a macro group!
Regards - Dave.

Date: Thu, 7 Jan 2010 12:36:39 +0530
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: pkkara...@gmail.com
To: excel-macros@googlegroups.com

Hello Anish,

Please check the attached file and let me know if this is what you were looking 
for.

run the macro testmulti()
You should get a true for all multibyte character strings

Regards,
Praveen 


On Wed, Jan 6, 2010 at 3:57 PM, Anish Shrivastava <anish....@gmail.com> wrote:

Experts
 
Please helppppp....or advice if it is possible...


---------- Forwarded message ----------
From: Anish Shrivastava <anish....@gmail.com>

Date: Tue, Jan 5, 2010 at 2:29 PM

Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
To: excel-macros@googlegroups.com



Hi Dave,
 
Attached please find the file with sample data, I have seprated titles 
Character wise...we have 3 categories..

ENGLISH, EUROPEAN (Diacritics) and Multibyte (Chinese, Japanese, Korean etc).

Please have a look and help me if it is possible.

Thank you very much!!
ANISh





On Mon, Jan 4, 2010 at 6:43 PM, Dave Bonallack <davebonall...@hotmail.com> 
wrote:


Please attach a workbook with a sample of English and non-English characters
Regards - Dave



Date: Mon, 4 Jan 2010 15:40:08 +0530
Subject: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: anish....@gmail.com
To: excel-macros@googlegroups.com 





Experts!!!
 
Any updates on below query??
 
Thanks!!
ANISh


On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava <anish....@gmail.com> wrote:


Hello Experts,
 
Thank you very much for helping me on my earlier queries.
Could you please help me in finding cells which contains multibyte characters.

I mean how can we find or select the cells which contains NON-English 
charecters.
We get the data from almost each country in this world to work on where we have 
2 caregories, ENGLISH DATA and NON-ENGLISH (Which is Multibyte), we do manual 
separation of these 2 caregories which takes hell lot of time and effort. Could 
you please suggest how can I automate it ?



It will save my lots of time and manual work..

Thanks!!
ANISH

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip


2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com


4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



 
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com


<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe






Check out the latest features today Get more out of Hotmail




-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip


2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com


4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com



 
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com


<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe






--

----------------------------------------------------------------------------------

Some important links for excel users:

1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com

3. Excel tutorials at http://www.excel-macros.blogspot.com

4. Learn VBA Macros at http://www.quickvba.blogspot.com

5. Excel Tips and Tricks at http://exceldailytip.blogspot.com





To post to this group, send email to excel-macros@googlegroups.com

If you find any spam message in the group, please send an email to:

Ayush Jain  @ jainayus...@gmail.com

<><><><><><><><><><><><><><><><><><><><><><>

HELP US GROW !!



We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe




                                          
_________________________________________________________________
Time for a new car? Sell your old one fast!
http://clk.atdmt.com/NMN/go/157637060/direct/01/
-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to