Excel Convert to lower case
http://www.xlninja.com/2012/07/30/con...
How do we convert it to lower case? or the other way round?
It's very simple.
There are three functions in Excel that can help with this issue.
First of all, the 'lower' function transforms a string of text in all lower case.
Its syntax is '=LOWER(text)' so whatever you specify as text within the parenthesis will be converted to all lower case.
'Text' can also be a reference to a cell containing the text that you want to convert.
For instance, '=LOWER(A6)'.
In a similar way, you can convert a string of text to all UPPER case by using the 'upper' function.
Its syntax is '=UPPER(text)'.
Finally, you can use the 'proper' function which will convert text by inserting a capital latter as the first letter of a word and lower case for all remaining letters.
Again, its syntax is '=PROPER(text)'.
This is especially useful when managing the conversion of names.