Auto change all caps to upper and lower case
 

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.
--
Gary''s Student - gsnu200832


"Roberson" wrote:

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.