[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

PROPER

Syntax:

PROPER ( string )

Description: Makes a lowercase version of string except that the first letter in string and any other letters in string that immediately follow a character that is not a letter, are converted to uppercase.

Arguments:

Name

Type

Description

string

text, reference

Designates the string to be converted.

 

Return Type and Value: text – A version of string such that the first letter in string and any other letters in string that immediately follow a character that is not a letter, are converted to uppercase. All other letters are converted to lowercase, and all other non-letters are unchanged.

[Example:

PROPER("12aBC d123aD#$%sd^") results in 12Abc D123Ad#$%Sd^
PROPER(A10) results in 12Abc D123Ad#$%Sd^, when A10 contains 12aBC d123aD#$%sd^

end example]