Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to capitalize first letter of every word in Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-05-2009
Member
 
Join Date: Feb 2009
Posts: 68
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....

Reply With Quote
  #2  
Old 11-05-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
  #3  
Old 11-05-2009
Member
 
Join Date: Jan 2008
Posts: 3,749
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.
Reply With Quote
  #4  
Old 11-05-2009
Member
 
Join Date: May 2008
Posts: 3,312
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/
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 03:13 AM.