=UPPER(LEFT(A1,FIND(",",A1))) & RIGHT(A1,LEN(A1)-FIND(",",A1))
--
Gary''s Student
gsnu200701


"Ben" wrote:

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.