Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert names to proper case (Excel 2007)

    Subject edited by HansV to be less vague than "Excel"

    I run a report a report of names in another program and save it to excel. The report produces the names in upper caps. I would like to have excel make them lower case with first letter in upper case. How can I do this? I would like it to be done once instead of cell by cell. The report I usually run is includes over 500 names. I will enclose a spreadsheet with a few names. Thank you in advance!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert names to proper case (Excel 2007)

    You could use the macro from post 739,933. If you store it in your personal macro workbook Personal.xls, you'll be able to use it in any workbook. Select the cells with names, then run the macro.

Posting Permissions

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