changing case in excel

[Guest]

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.

 

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

thanks Gary it worked

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

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3