changing case in excel
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.
|