How to capitalize first letter of every word in Excel

[Faakhir]

Sponsored Links

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....

[Eric B]

Here's your required macro 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.

[Sam.D]

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.

[Raine]

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/