Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Proper Function

Posted 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?

Thanks


Re: Proper Function

Posted 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 Function

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