If the names are always separated by a comma then try:

=UPPER(LEFT(J2,FIND(",",J2)))&PROPER(RIGHT(J2,LEN( J2)-FIND(",",J2)))

Adjust for the correct cell and copy down then if necessary copy and Paste
Special values over the top of the original data.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Ben" wrote in message
...
How do I change the case of a name in Excel? My example is as follows

If I want to change "Hughes,Gavin" to "HUGHES,Gavin" is there a function I
can use?

I know there's one to change the whole name but what about just the
surname?

I have over 700 names to change so would like a quick option.