How do I change proper case in Excel?
Posted by admin
Sue Zee asked:
I have read the past answers but still dont understand how to change everything to proper case. If someone could tell me how step by step! I have about 300 names addresses that are mostly all caps that I have to change to be able to do a mail merge.
I need to do this to about 300 names. I know it has something to do with copy paste special value but I’m unsure exactly how! I need detailed directions!
Thank You!!!
Website content
I have read the past answers but still dont understand how to change everything to proper case. If someone could tell me how step by step! I have about 300 names addresses that are mostly all caps that I have to change to be able to do a mail merge.
I need to do this to about 300 names. I know it has something to do with copy paste special value but I’m unsure exactly how! I need detailed directions!
Thank You!!!
Website content
November 19th, 2008 at 12:11 am
Assuming column A is the name. In some other column directly beside the name you want to convert type. =PROPER(A1)
The name should now appear in that new column in the proper case.