Excel 2010-Upper Case Letters to Every Word in Spreadsheet

Hi Experts,
I need to change the first letter of every word in my spreadsheet to upper case, is there a formula I can use to do this with 1 action or do i have to manually change each letter to upper case?
This will need to apply to each word within a spreadsheet that has around 2000 line entries
Frank .SBuilding EstimatorAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Frank .SConnect With a Mentor Building EstimatorAuthor Commented:
Hi Experts, thankyou for your help. It appears all i needed to do was;
=Proper(cell reference)
0
 
Rgonzo1971Commented:
Hi

Pls try on your selected cells

Sub DoUpperCase()
For Each cell In Selection
        cell.Value = WorksheetFunction.Proper(cell.Text)
Next
End Sub

Open in new window


Regards
0
 
Frank .SBuilding EstimatorAuthor Commented:
Hi Rgonzo1971,
I have pasted this code into the worksheet, but I need a lot more directions as to what else i need to do etc?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rgonzo1971Commented:
Hi,

first select the cells you want to change then run the code, the code cannot change the result of formulas.

Regards
0
 
Frank .SBuilding EstimatorAuthor Commented:
Hi expert, i have selected the cells but dont know how to then run the code in excel 2010?
0
 
Rgonzo1971Commented:
Goto View/Macros/View Macros then you should find DoUpperCase then Click Run

Regards
0
 
Saqib Husain, SyedEngineerCommented:
Right-click on the sheet tab name
Select View code
From the menu      Insert > Module
Paste the given code in the VBA window
Close the VBA window
Press Alt-F8
Select the macro name
Click on run
0
 
Martin LissOlder than dirtCommented:
If you want to do this more than once then after the "Select the macro name" in ssaqibh's steps, click the 'Option…' button and place a letter like 'z' in the 'Ctrl+' box. From then on all you need to do to run the macro is to press Ctrl+z.
0
 
Martin LissOlder than dirtCommented:
Did any of the above help you?
0
 
Frank .SBuilding EstimatorAuthor Commented:
all expert suggestions were not what worked for me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.