If you want to introduce some consistency to text in your spreadsheet you can make use of LOWER, UPPER and 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.