excel replace lower case with upper case code example

Example: excel make case first capital others lower

PROPER("name of person or place")