Auto change all caps to upper and lower case

  • Thread starter Thread starter Gary''s Student
  • Start date 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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upper / Lower Case 1
change to upper/lower case 1
CHANGE LOWER CASE TO UPPER CASE? 1
Formatting cells to only upper case 5
All Caps, / All Lower, not the function 5
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING 3
convert lower to upper case automatically without using UPPER 6
How do I convert addresses to all caps in Office 2007? 3

Back
Top