We Designers are so used to just browsing over to the text panel and changing the text case to either all caps or title case! whatever our favorite brand prefers. However once in a while when we have to venture out of our comfort zone into the interesting world of spreadsheets we might need to get this solved to ensure that Mr. Jones is not insulted by sending him an automated mail with his name in small letters as it is in the database.

To change Excel Sheet text case details to Proper or as we designers call it Title Case Create a column next to the values you want changes and add this formula  =PROPER(A1), then once you have included this formula. Copy all the data and paste in the old column; make sure you are only pasting the values!

Bang well done… database mastery on its way! Well, I hope that this will be a valued fix for your next database cleanup!