Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > PROPER
 

PROPER(text)

 
 Returns the text string with the first letter of every word as a capital letter.

 textThe text string you want to convert.

 REMARKS
 
  		• The "text" can be a formula that returns text, or a cell reference containing text.
     
  		• Letters that do not follow another letter will also be capitalised (including punctuation)
     
  		• This function is similar to the LOWER() and UPPER() functions.

     EXAMPLES
     
     A
    1=PROPER("this is a TITLE") = This Is A Title
    2=PROPER("better solutions") = Better Solutions
    3=PROPER("1a2b3c4d") = 1A2B3C4D
    4=PROPER("shouldn't") = Shouldn'T
    		 
     Functions - P | Index - P | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top