If you want to introduce some consistency to text in your spreadsheet you can make use of LOWER, UPPER and PROPER functions.

A B C D E
1 Lotus ELISE SilVer LOTUS ELISE lotus elise Lotus Elise

< C Function >

=UPPER(A1)

< D Function >

=LOWER(A1)

< E Function >

=PROPER(A1)

Use can incorporate these functions, for example along with & to concatenate cells

e.g.

=UPPER(B1&" "&A1)

returns SILVER LOTUS ELISE

Note: Also, see the Flash Fill command on how to copy cells based on an example cells formatting.