If the name was in A2

=PROPER(A2) Changes text to Title Case (Jane Doe)

or
=UPPER(A2) Changes text to all UPPERCASE (JANE DOE)
=LOWER(A2) Changes text to all lowercase (jane doe)


"CMD" wrote:

I have a spreadsheet that a user entered everything in caps. I need to
change at least 4 columns to titlecase (ie. JANE DOE to Jane Doe). How can I
do this all at once without going to each cell.