A little shorter version.........

=UPPER(LEFT(A1,FIND(",",A1)))&MID(A1,FIND(",",A1)+ 1,99)

Vaya con Dios,
Chuck, CABGx3




"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.