Microsoft Office Tutorials and References
In Depth Information
Using LOWER, UPPER, or PROPER to Convert Text Case
text item. The text items can be text strings, numbers, or single-cell referen-
The problem with this function is that it can select only single-cell ref-
erences. An attempt to use =CONCATENATE(A2:B2) returns a #VALUE! error.
If you have to enter =CONCATENATE(A2," ",B2), it is easier to use =A2&"
to Convert Text Case
Three functions — LOWER, UPPER, and PROPER — convert text to or from cap-
haphazard fashion. Some products used lowercase, and some products used
uppercase. Column B uses =UPPER(A2) to make all the products a uniform
LOWER ,, UPPER
UPPER , or
, or PROPER
PROPER to Convert Text Case