Take the Excel Name Fix Challenge

Last week, in my Contextures Newsletter, I posted an Excel Name Fix challenge. There was a short list of names, which needed to be fixed. Then we needed to count how many were fixed. Take the challenge yourself – download the workbook to see how you’d solve it.

Excel Name Fix Challenge

Here the challenge that I posted in the newsletter —

If people enter their names in a sign-up form, you might end up with a mixture of upper and lower case letters. You can see an example in the screen shot below.

This week’s challenge is to clean up that list. Using Excel formulas, make these changes to the list:

Show the corrected name in column B, with only the first letter of each name in upper case. For example, Fred Jones instead of FRED JONES.