Change entire column in spreadsheet from upper case
 

imported excel spreadsheet has names in all caps. is there an easy way to
change these? for example John Smith instead of JOHN SMITH

Change entire column in spreadsheet from upper case
 

=PROPER(A1)

HTH
--
AP

"JLS" a écrit dans le message de news:
...
imported excel spreadsheet has names in all caps. is there an easy way to
change these? for example John Smith instead of JOHN SMITH