Pages

Wednesday, April 13, 2011

Use the UPPER function to convert text from lowercase to uppercase - Text Functions - Microsoft Excel Tutorials


To convert a text string to all uppercase letters, the UPPER function is used. This function has the following syntax:

UPPER(text)

text: Text to be converted to all uppercase letters. The text can be either a reference or a text string.

To convert a text string to uppercase:

1. In cells A2:A8 type any text in lowercase letters.
2. Select cells B2:B8 and type the following formula: =UPPER(A2).
3. Press <-Ctrl+Enter->.


Watch the Video Tutorial - https://www.youtube.com/watch?v=5MNPKGJSv3c

Hope You Like This Tutorial - Give Comments

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews