Authored by Vince Russell on 01 July 2005 at 09:09PM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips

The PROPER function

Excel is proper great!

I’m the sort of person that cannot bear to see his name in all lower or all upper case, I want my first and last names to start with a capital letter! Preferably the capital letter that those names actually begin with, as in, Mince Bussell will not suffice, although it is quite amusing, I agree!

Luckily, formatting these sort of things in Excel is very easy!! The PROPER function can turn "vince russell" (I shudder to even type poorly formatted text) into "Vince Russell". Let’s say in Excel you have a column full of poorly formatted names, and these names are in column A, starting from the very top. In column B type,

=PROPER(A1)

hit return and copy the formula down as far as you need. Column B will now contain some marvellously formatted text!

Download File Download the example Excel file


See also
   Formatting names correctly

Authored by Vince Russell on 01 July 2005 at 09:09PM
Current rating: 3 out of 5 stars!
Filed under: Excel Tips


Comment on this article

  

  


Remember Me?