Change source text in Excel from all caps to upper and lower case.

  • Thread starter Thread starter Guest
  • Start date Start date
This would be an easy way:
http://www.cpearson.com/excel/case.htm

Or, if VBA isn't an alternative for you:
If Column A contains the Names, Insert a blank column after Column A.
If A3 is the first name in the list, put =Proper(A3) into B3. Copy the
formula down.
Then, select all the new names in Column B and Copy.
Edit | Paste Special | Values.
Delete the original uppercase column.
Repeat for each column you need to convert.

tj
 
Are you using mailmerge?

Maybe it would be easier to merge into word, fix in word, then print.

Word has format|change case built in.
(after you select your text (or all the document?).)
 
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

change to upper/lower case 1
How do I convert addresses to all caps in Office 2007? 3
Change all text on Spread sheet 1
How do you change the Capitalization in an Excel Workbook? 7
Formatting cells to only upper case 5
Upper / Lower Case 1
CHANGE LOWER CASE TO UPPER CASE? 1
All Caps, / All Lower, not the function 5

Back
Top