PROPER function

This function will function will capitalize the first letter of each word.

Syntax

PROPER(Text)

  • Text (required) – This is the text string which you want to capitalize the first letter of each word.

Example

In this example we capitalize the first letter of each word.

=PROPER(A2)PROPER

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Related Posts

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us on social media to stay up to date with the latest in Microsoft Excel!