Microsoft Office Tutorials and References
In Depth Information
In cell E13, text was entered by someone who never turns off Caps Lock. You
can convert this uppercase to lowercase with =LOWER(E13).
In column E, you see a range of names in uppercase. You can use =PROPER(E2)
to convert the name to proper case, which capitalizes just the first letter
of each word. The PROPER function is mostly fantastic, but there are a few
cells that you have to manually correct. PROPER correctly capitalizes
names with apostrophes, such as O ’ Rasi in cell F3. It does not, however,
correctly capitalize the interior cin McCartney in cell F4. The function is
also notorious for creating company names such as Ibm, 3m, and Aep.
The LOWER function converts all uppercase letters in a text string to
lowercase. The argument textis the text you want to convert to lowercase.
LOWER does not change characters in textthat are not letters.
The PROPER function capitalizes the first letter in a text string and any
other letters in text that follow any character other than a letter. It con-
verts all other letters to lowercase letters.
The argument textis text enclosed in quotation marks, a formula that returns
text, or a reference to a cell containing the text you want to partially cap-
The UPPER function converts text to uppercase. The argument textis the text
you want converted to uppercase. textcan be a reference or text string.
to Remove Trailing Spaces
If you frequently import data, you might be plagued with a couple of annoying
situations. This section and the next one deal with those situations.
TRIM to Remove Trailing Spaces