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-
ces.
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&"
"&B2.
Using
Using LOWER
to Convert Text Case
Three functions LOWER, UPPER, and PROPER convert text to or from cap-
ital letters. In Figure 11.50 , the products in column A were entered in a
haphazard fashion. Some products used lowercase, and some products used
uppercase. Column B uses =UPPER(A2) to make all the products a uniform
uppercase.
LOWER ,, UPPER
UPPER , or
, or PROPER
PROPER to Convert Text Case
Search JabSto ::




Custom Search