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