Check out the Proper() function. It changes any case to title case and
you can copy it to a range of cells to apply it to your data.