Auto change all caps to upper and lower case

  • Thread starter Gary''s Student
  • Start date
G

Gary''s Student

Two ways. Say you have all upcase text in column A. In B1 enter:

=PROPER(A1) and copy down

The second way would be to use a macro to do the same thing.
 
R

Roberson

I received a spreadsheet with 500 names that need to be merged into labels.
Entries are in all caps. Is there a way to convert names into proper upper
and lower case without re-entering them? Using 2003 XP.
 
Top