Dear Jayavelu Thanks for the reply. That you have taken time and effort to reply my query speaks volumes of your commitment.
However as a constructive feedback and to make you provide even better answers, I say the following : - As you would notice from my mail I wish to change the first letter to UPPER case and rest of the letters to LOWER case. - You enclosed spread sheet does NOT seem to do that in case of examples like , name_fIVe ' name SIX , name sevEN etc... Please accept my thanks and keep up the good work. regards Subu On Jun 24, 4:48 pm, JAYAVELU SUN <jayavelu....@gmail.com> wrote: > Hi subu > > find the attach which is solve your problem > > Jayavelu > 9941260857 > > On Wed, Jun 24, 2009 at 1:40 PM, Subu <mail_to_s...@yahoo.com> wrote: > > > Dear List members and XL Gurus > > > I have an XL sheet with a column that looks something like > > > Name_One > > nAme_two > > NAME_THREE > > name_four > > name_fIVe > > name SIX > > name sevEN > > > ...and so on > > > I wish to get them all with the first Character in upper case and the > > rest all in lower case > > > I.e. something like > > > Name_one > > Name_two > > Name_three > > Name_four > > Name_five > > Name six > > Name seven > > > Thanks in advance > > Best regards > > > Subu > > > > convert the first letter of every cell.xls > 18KViewDownload --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
