Tip Printed from ExcelTip.com
Converting Text to Uppercase
Use the UPPER function to convert text to uppercase.
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