Look at PROPER function:

In helper column(s) put:

=PROPER(A2) assuming data in column A and copy down as required.

Then Copy & Paste Special=Values (the latter to either helper or original
column) and delete redundant column(s)

HTH

"Kimberly in Palm Springs" wrote:

I need to change Upper text to Upper and lower text , example JOHN to John,
in entire column. First and last names are in seperate columns typed in excel
spreadsheet. This is for a mail merge.