Which function would you use to make sure all names are prepared for a mailing label?

Use the PROPER function to capitalize the first letter of each word in a name, such as changing “jane doe” to “Jane Doe.” This formatting is appropriate for names on mailing labels. UPPER and LOWER change all letters to uppercase or lowercase, while TODAY returns the current date.

AI-written and checked against the verified answer.