Excel tip of the week – How to change all CAPS to Initial Caps

Posted by Spike Uncategorized

Here at Spike we often get the question “How do I tidy up inconsistent first name and last name capitalisation in my database?”.

Here’s a little trick you can use in Excel:

Excel Screenshot

In cell B2 write the formula =Proper(A2)

A2 is where the existing first names are in the spreadsheet.

Then copy the formula down the column.

Excel Screenshot 2

Done!