20211027_720pmp4 -

If you are looking to convert the filename into "proper case" (where the first letter of every word is capitalized), the result would be: 20211027_720Pmp4 How "Proper Case" Works

In data applications like Microsoft Excel and TeamDesk , the function capitalizes the first letter of a string and any letter that follows a non-letter character (like a space or underscore).

2 Replies * JMB17. Bronze Contributor. Feb 17, 2021. Try Paste Special - Value (from the paste button on the home tab). * Abiola1. Microsoft Community Hub Proper - TeamDesk Documentation 20211027_720pmp4

Because your text contains an underscore ( _ ), the "P" immediately following it is capitalized. Other Formatting Options

20211027_720pmp4 (Only the very first character is capitalized; numbers remain unchanged). Uppercase: 20211027_720PMP4 (All letters capitalized). If you are looking to convert the filename

720p MP4 (Converting the date and technical specs into a human-friendly title).

Depending on how you want to use this text, you might prefer one of these styles: Feb 17, 2021

You can use online tools like Case Converter or Convert Town to quickly switch between these formats. Using the =PROPER(text) Function - Microsoft Community Hub

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More