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.

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

thanks Gary it worked

"Gary''s Student" wrote:

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

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.

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.