Hello Vinay.
You can wirte the formula as per below.
a b
1 kalpesh =upper(a1)
Hope it solves your problem.
On Sat, Sep 20, 2008 at 5:22 PM, vinay keni <[EMAIL PROTECTED]> wrote:
> dear all,
>
> i want to know how to change from small letters to capital
> letters as i have some 500 persons name which i have typed in small letters
> now wants to change those things in the Big letters ..... reply fast its
> urgent
>
> --
> Regards,
> Vinay Keni
>
> >
>
--
Thank you & Kind Regards
Kalpesh Velinkar
email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Mob. : 91-9869044968
Tel. : 91-22-66991051
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
