Thanks a Ton to all the enthusiasts and Gurus who responded
Like the last time I am overwhelmed by the response. If I may be permitted, I wish to add some comments BELOW the replies I have seen so far On Jun 24, 3:45 pm, Swapnil Palande <swapnilp1...@gmail.com> wrote: > Hi, > Use following formula: > =UPPER(LEFT(B15,1))&LOWER(RIGHT(B15,LEN(B15)-1)) > Regards, > Swapnil. > *This worked Swapnil P : Great. Simple one, did the job* > On Wed, Jun 24, 2009 at 4:16 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > > Hi Subu, > > > Use the following function:- > > =PROPER(MID(A1,1,FIND("_",A1)-1))&"_"&LOWER(RIGHT(A1,LEN(A1)-FIND("_",A1))) > > > Solved workbook is also attached for your reference. Thanks > > Dilipandey *Dear Dilpande* : *This worked IF the input value had an _ or underscore*. If you see the examples I have given the name SIX and name sevEN do not have underscores - NO _. The formula you had given does not work in case there are no _ in the input value > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > 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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---