When you look at your data, do you see a mish mash of formats? Do some people use camel case, some all lowercase, some upper? Here is a quick script that you can use to capitalize the first letter in your single word strings.
Sql Server Management Studio is very robust and can do many things, but like any other product cannot do everything. Luckily there are add-ins available that fill in some of the gaps. My favorite and one I use every single day is SSMSBoost, (I no longer use it due to the change in the community license and the useful functions being taken away.)