Function Proper()

Proper()

This function is used to convert the text in title case (title case means every word has first letter as capital, e.g. - Excel Matic)


Syntax:

= Proper (Text)

Text = is the text, or reference to a cell that contains the text, that is required to be converted to title case


Example:

Below are some examples to illustrate the usage of Proper() function. For these illustrations let us assume that cell A1 contains text - ExCeL mAtIc
  • = Proper("hELLO World") - result will be - Hello World
  • = Proper("HeLlO WoRlD") - result will be - Hello World
  • = Proper(A1) - result will be - Excel Matic
Note: this function can take text in any case to convert to title case
Share on Google Plus

About Rishie Khurana

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Saturday, May 30, 2009

Function Proper()

Proper()

This function is used to convert the text in title case (title case means every word has first letter as capital, e.g. - Excel Matic)


Syntax:

= Proper (Text)

Text = is the text, or reference to a cell that contains the text, that is required to be converted to title case


Example:

Below are some examples to illustrate the usage of Proper() function. For these illustrations let us assume that cell A1 contains text - ExCeL mAtIc
  • = Proper("hELLO World") - result will be - Hello World
  • = Proper("HeLlO WoRlD") - result will be - Hello World
  • = Proper(A1) - result will be - Excel Matic
Note: this function can take text in any case to convert to title case

Function Proper()SocialTwist Tell-a-Friend

0 comments:

Post a Comment