Beginner

Capitalize the first letter of each word

Turn messy lowercase names into clean, title-cased ones.

The formula

=PROPER(A2)

How it works

Before
john smith
After
John Smith

PROPER capitalises the first letter of each word.

Functions used

PROPERUPPER