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

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!

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"