Monday, March 16, 2009

How to Change Upper and Lower Text in Excel

Microsoft Excel Tips

The following tips will show you the easy way to change upper and lower text in Excel:

1. Open Excel program
2. Type GoKHiel In cell A1
3. Type =Lower(A1)In cell B1

4. Press Enter

If you want to change to Upper case type =Upper(A1) in cell B2




If you Want to change the text with the first letter is Capital letter, type =Proper(A1) in cell B3




Related Topics:
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Change Upper and Lower Text in Excel
How to Repair corrupted files in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
How to separate the cell contents in Microsoft Excel
Microsoft Excel 2007: How to take limit value to the cell

No comments:

Post a Comment