How do I change the case of a string with SQL?

Although rarely, it could happen that you end up with fully capitalized strings in SQL. Whilst there's often nothing wrong with the data quality, it's not very appealing to be showing the users of your analyses data in capital letters. Personally, I always get the feeling of being shouted at when I see fully capitalized …

10 Functions that Help you Crunch Text Strings in Excel

It has often been the case in the course of my assignments that I've had to do quite some data prep in Excel before I could have a clean dataset to crunch. If you also need to do this in Excel, below are 10 functions that I have found indispensable. The datasets I'm going to …