changing case in excel

B

Ben

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

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

[email protected]
[email protected] with @tiscali.co.uk
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top