Excel PROPER Function - Capitalize each word in a text string | Excel One Minute Quick Reference

The PROPER function in Excel will capitalize each word in a text string. If you have a list of employees and their names are all caps, PROPER will change CHRIS MENARD to Chris Menard, and change TaMMY oWens to Tammy Owens.

Other Examples of PROPER function
Input Output
MARY WILSON Mary Wilson
mary wilson Mary Wilson
747 747 (converted to text and left align)
1000 ITEMS 1000 Items

#msexcel #microsoftexcel #chrismenard #chrismenardexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Excel PROPER Function - Capitalize each word in a text string | Excel One Minute Quick Reference канала Chris Menard