Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Proper FunctionPosted by silas on August 24, 2000 6:56 AM
How do i use the 'Proper function in Excel 7.0 to capitalize the first letter of all the text in a column?
Re: Proper FunctionPosted by Robert on October 20, 2000 4:23 PM
//Ok. Up front before you start typing anything.
How do you make the entire worksheet understand you want the proper function for every cell? From scratch!
Re: Proper FunctionPosted by Scott on August 24, 0100 9:40 AM
This one is straightforward. You can use the PROPER formula in multiple ways and that is what makes it powerful:
- You can change text values you type into the formula yourself
- You can reference text from somewhere on the spreadsheet (named ranges, etc.)
- You can reference a cell that contains text values
Some examples of the formula:
PROPER("this is a TITLE") equals "This Is A Title"
PROPER("2-cent's worth") equals "2-Cent'S Worth"
PROPER("76BudGet") equals "76Budget"
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.