=PROPER(A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Beagle Lover" <Beagle wrote in message
...
I need to change names that are in capital letters in an Excel Spreadsheet
to
titlecase (eg: HARRY to Harry).