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:



Set a Default Table Style in Excel 2007
Set a Default Table Style in Excel 2007
Table styles are a great way to add interest and organization to your Excel 2007 spreadsheet.
Difficulty:
Built-In Means Of Password Protection In Microsoft Excel Documents
Built-In Means Of Password Protection In Microsoft Excel Documents
The recent versions of the MS Excel provide their users with advanced features for organizing various variants of protecting MS Excel documents against being cracked and information stored in them against being accessed. They include completely blocking access to a document, forbidding saving changes to it and protecting separate sheets and cells. Now let us study the means of protecting MS Excel documents in a more detailed way.
Difficulty:
Excel VBA - Control the Program Flow
Excel VBA - Control the Program Flow
While executing the program the flow generally goes top to bottom, it means from first line of the program to the last line. But some times we need interrupt the flow of the program. For this purpose we have several statements to achieve this task.
Difficulty:
Introduction to Cells Formatting
Introduction to Cells Formatting
Introduction to Cells Formatting
Difficulty:
Password-Protect a Worksheet from Viewing
Password-Protect a Worksheet from Viewing
Keep prying eyes from viewing a worksheet, unless they have the password.
Difficulty: