Subscribe
Tutorial search

Change Text to Upper- or Proper Case - Excel tutorial


When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.
Category: Excel > Macros - Difficulty:


More cool Excel tutorials:



Data Validation - Dependent Lists
Data Validation - Dependent Lists
This tutorial will show you how to create a dependent list on Excel. This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3. Cell B3 (City) will pull a city based off of the users selection.
Difficulty:
Excel Macro
Excel Macro
Creating macros in Excel differs from one version to another. Please choose your version.
Difficulty:
Charting Hacks
Charting Hacks
Charts are one of Excel's most popular features, giving spreadsheets visual power beyond mere calculations. Although Excel's chart capabilities are impressive, many times you'll want to go beyond the basic functionality provided by the software's built-in Chart Wizard to create charts that are more responsive to changes in data, or you simply will want to go beyond the range of options Excel most obviously provides. This tutorial enable you to do all of this and more.
Difficulty:
Convert Text Numbers to Real Numbers Convert Text Numbers to Real Numbers
Convert Text Numbers to Real Numbers Convert Text Numbers to Real Numbers
Remember that numbers in Excel are right-aligned by default, and that text is left-aligned by default.
Difficulty:
Use Multiple Windows in Excel 2007
Use Multiple Windows in Excel 2007
Use multiple window in Excel 2007 to organize multiple copies of the same workbook in an arrangment in your screen that makes it easier for you to compare and edit data. In this tutorial, you will learn how to open multiple windows, arrange the multiple windows and save them as a workspace in Excel 2007.
Difficulty: