+ Reply to Thread
Results 1 to 9 of 9

Convert 1st letter of word to Upper Case and rest to lower case

  1. 05-23-2013, 10:58 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Convert 1st letter of word to Upper Case and rest to lower case

    Hello:

    Please refer to attached sheet.
    I have long list of names, I am showing you sample list in Sheet1

    COlumn A and Column D i need help.
    As you can see inconsistant with uuper and lower case letter.

    I need VB Macro to convert all words starting with upper case and rest be lower case in column A and D.

    Please let me know if any questions

    Thank you.

    Riz
    Attached Files Attached Files
    Last edited by rizmomin; 05-23-2013 at 11:30 AM.
    Reply With QuoteRegister To Reply
  2. 05-23-2013, 11:10 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Riz,
    I do no think you need a VBA for this task. A simple formal does the job. In column F1, put this formula
    =PROPER(A1) for column A and drag it down and copy it for column D
    Reply With QuoteRegister To Reply
  3. 05-23-2013, 11:12 AM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    =PROPER(A1)

    This convert the first letters of your word to UPPER.

    Then you can:

    1)record a macro

    2)use this function in an empty column and hide column A

    3)use this function in an empty column and then copy>>special paste>>only values in column A. Delete the new column.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 05-23-2013, 11:17 AM #4
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Fortis,
    I though proper function converts a word in to proper: 
    Please Login or Register  to view this content.
    INTO
    Please Login or Register  to view this content.
    Not only the first letter, but also the first letter of the next word
    Reply With QuoteRegister To Reply
  5. 05-23-2013, 11:18 AM #5
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Hi Guys:

    The reason i need the macro is because the data is populated by another macro and i want to incorporate the code with that.

    I really need a VB macro to perform the task.

    Please help and let me know if any questions.

    Thank you

    Riz
    Reply With QuoteRegister To Reply
  6. 05-23-2013, 11:23 AM #6
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Convert 1st letter of word to Upper Case and rest to lower case 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-23-2013, 11:26 AM #7
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Hi AB33:

    You are super help...

    Thank you so much

    Riz
    Reply With QuoteRegister To Reply
  8. 05-23-2013, 11:42 AM #8
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Riz,
    You are welcome!
    Reply With QuoteRegister To Reply
  9. 05-23-2013, 11:44 AM #9
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Convert 1st letter of word to Upper Case and rest to lower case

    Quote Originally Posted by AB33 View Post
    Fortis,
    I though proper function converts a word in to proper: 
    Please Login or Register  to view this content.
    INTO
    Please Login or Register  to view this content.
    Not only the first letter, but also the first letter of the next word
    This is true!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1