Converting Capitals in Word and Excel

So back to our company telephone lists that can be such a mess, or any list type information in this case.  Quite often the values are all typed in capital letters.  Capital letters are shouting, not great etiquette.

In Word you can convert all capitals to only the first letter capitalised by using Change Case option on the ribbon.

Capitalize each word

Capitalize each word 2In Excel, you would use a formula to do this.  Create a new column next to the one you want to fix.  Type in =PROPER and reference the cell you want to change, in this case, A2, then Enter.

Excel Capitals Formula 1The field will display with the correct formatting.

Excel Capitals Formula 0Then you can just fill the rest of the cells by clicking the bottom right corner of the cell and dragging it down to all the fields you want to change.

Excel Capitals Formula 2However, you can’t just delete the source column (A above), because it’s using a formula reference so if you delete it,  you will get errors.

Excel Capitals Formula 3aYou need to create another column, copy the values and then click the dropdown menu on Paste and select Values.

Excel Capitals Formula 3That will strip out the formulas and you can then delete the other columns.

Excel Capitals Formula 4And end up with clean data.

Excel Capitals Formula 5Sound shleppy?  It’s either that or retype 500+ names….

Big THANK YOU to Louise Currie for the Excel tip!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.