Results 1 to 4 of 4

Thread: How to capitalize first letter of every word in Excel

  1. #1
    Join Date
    Feb 2009
    Posts
    69

    How to capitalize first letter of every word in Excel

    hi friends,

    I have created an Excel file in which the hundred of names are listed. I want to make the first letter of every word in the file in capital form. It would take a considerable time to manually navigate each and every word in the file and change the first letter of the word to uppercase.

    Can anyone provide me the macro code so that I can easily capitalize the first letter of every word in excel ?

    thanks....

  2. #2
    Join Date
    Apr 2008
    Posts
    4,644

    Re: How to capitalize first letter of every word in Excel

    Here's your required macro code -

    Code:
    Sub Proper_Case()
    
    '
    'This will make the first letter of the text within any selection of 
    'cells uppercase.
    '
    For Each x In Selection
    x.Value = Application.Proper(x.Value)
    Next
    End Sub
    This macro will capitalize the first letter of any selected cell in Excel.

    Note -
    This macro works on any selection of cells in columns, rows, or a combination of the two.

  3. #3
    Join Date
    Jan 2008
    Posts
    3,758

    Re: How to capitalize first letter of every word in Excel

    Create an extra (temporary) column, and use the PROPER function to convert your existing text. Next, Copy and Paste Special - Paste Values over the original column and delete the temporary column.

  4. #4
    Join Date
    May 2008
    Posts
    3,319

    Re: How to capitalize first letter of every word in Excel

    There are two ways you can do this -

    1. PROPER fuction - by using PROPER function, you will need to insert another column, then delete the original (as mentioned in the above post)

    2. ASAP Utilities add-in - http://www.asap-utilities.com/

Similar Threads

  1. MS Excel & Word in Apad M7009
    By AisleyP in forum Portable Devices
    Replies: 9
    Last Post: 27-11-2011, 03:05 PM
  2. Use of IPad for word/excel
    By McKayla in forum Portable Devices
    Replies: 4
    Last Post: 16-06-2010, 04:58 PM
  3. How to capitalize letter in mail
    By Wenro in forum Technology & Internet
    Replies: 6
    Last Post: 30-05-2010, 12:05 AM
  4. Formula to count the occurrences of specific letter in excel
    By Mithun Seth in forum Windows Software
    Replies: 5
    Last Post: 09-01-2010, 12:03 PM
  5. Connecting between Excel and Word
    By Windowed in forum Windows Software
    Replies: 5
    Last Post: 30-12-2009, 09:55 AM

Posting Permissions

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