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:
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.