If you want to introduce some consistency to text in your spreadsheet you can make use of http://coolcami.com/products/?product_sort=asc LOWER, follow url UPPER and http://mykrumlov.com/cesky-krumlov-flood-damage-update/ PROPER functions.
|1||Lotus ELISE||SilVer||LOTUS ELISE||lotus elise||Lotus Elise|
< C Function >
< D Function >
< E Function >
Use can incorporate these functions, for example along with & to concatenate cells
returns SILVER LOTUS ELISE
Note: Also, see the Flash Fill command on how to copy cells based on an example cells formatting.