|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
Written by Upendra Kumar
|
|
Saturday, 07 July 2007
Category MS Excel 2007 - Formulas.
|
| |
| General Information |
| |
 |
| |
|
Using Formulas
|
| |
|
| |
|
In this tutorial, you will learn how to use the formulas. |
| |
| Using Formulas |
| |
| 1) Open Sample.xlsx book. |
| |
|
| Illustration 1: Sample book. Click here to view larger image. |
| |
| 2) Select cell H1. Write Table Name as new column name. |
| |
| 3) Select cell H2. |
| |
| 4) Select the Insert Function command from the Functions library group in the Formulas Tab. |
| |
|
| Illustration 2: Function Library. |
| |
| 5) Select the RIGHT function from the function list in Text Category. Press the Ok Button. |
| |
|
| Illustration 3: Function categories. |
| |
| 6) Select the cell B2, which contains the text where you want to extract only the table name by discarding the dbo. Text. |
| |
|
| Illustration 4: Text to evaluate in cell B2. |
| |
| 7) You wants to extract all text by discarding the four initial characters (dbo.). As the formula requires the characters quantity to extract, you need
calculate the string length and then discard 4 characters. |
| |
| 8) The function LEN(B2) will return the string length. |
| |
| 9) LEN(B2) - 4 will return the total string length discarding 4 characters. |
| |
|
| |
|
|
|
|
|
|
|
|
|
|
