Making a fully capitalized list into having just Proper Capitalization

  • Thread starter Thread starter Gabriel Slack
  • Start date Start date
G

Gabriel Slack

I have a worksheet that has 642 addresses in it. The
company name, contact name and address are in all CAPS.
I need to change it so that only the first letter in each
word is capitalized. Can someone help me? Thank you
very much in advance for your support.

Gabriel Slack
 
Gabriel

Use a 'helper column' alongside your data. In this use the PROPER()
function, copy it down, and then Copy/Paste Special/Values.

Andy.
 
Andy,

You da' man!!! Thank you so much for your assistance, I
really appreciate it. I owe you one. Thank you.

Gabriel
 
Hi Gabriel,
You solved your current problem with use of the PROPER Worksheet
Function and several helper columns, but you are likely to have to
do this again and a simpler usage would be to use a macro see
http://www.mvps.org/dmcritchie/excel/properhtm
which eliminates the need for helper columns as the change is made
in place. It also has some provisions for handling last names if
they are in their own column or at least on left side of a cell..
 
Back
Top