» Converting Text to Uppercase
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
The UPPER function is in the Text category in the Insert Function dialog box.
Example:
Text in lowercase: george w. bush
The function: =UPPER(A1)
Result: GEORGE W. BUSH

Book Store:
Re consider the same
shobha
After getting the result of A1 Cell in A2 column, we will delete the text of A1, so as soon as we deletes the text of A1 automatically the A2 cell text also will get delete. pls confirm me regarding the same
What about the whole column ?
Harish
What should we do if we want everything in the column or row to be converted to upper or lower case ???
upper case
Deb
How do I make a column or row all upper case when some of the text is lower case
upper case
Deb
How do I make a column or row all upper case when some of the text is lower case

