» 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:
Recommended Books:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Windows XP Annoyances
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Definitive Guide to Excel VBA
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
