Put names into proper case

This can easily be done in Excel with the PROPER function.

PROPER function

ThePROPER functionautomatically reformats text so that all words are capitalized.

At the same time, it lowercases all other text.

Formula to put names into proper case with last name first

The result is returned to PROPER, which capitalizes each word as before.

Numbers, punctuation, and spaces are not affected.

The Excel TEXTBEFORE function returns the text that occurs before a given substring or delimiter.

Formula to put names into proper case with last name first

The Excel TEXTAFTER function returns the text that occurs after a given substring or delimiter.

Formula to put names into proper case with last name first

Excel formula: Remove leading and trailing spaces from text

Excel formula: Join first and last name

Excel formula: Get first name from name

Excel formula: Get last name from name

Excel formula: Get middle name from full name

Excel PROPER function

Excel TRIM function

Excel TEXTBEFORE function

Excel TEXTAFTER function

Formula to put names into proper case with last name first