## Why To Use Left Function in Microsoft Excel?

The Left function is used to get first N characters from the given text string or the text contained in a cell.### Syntax of LEFT Function in Excel

**LEFT(Text, Number_of_characters)**

For example, the function LEFT("Normal",3) will return Nor.

### Syntax of LEFT function with Cell Reference

**LEFT(CellReference, Number_of_characters)**

For example, let the cell A2 contains the text

**Humanity**, the function

**LEFT(A2,5)**will return

**Human**.

Similarly if Cll A12 contains "England" then Left(A12,5) will give "Engla" that is first five characters of contents of cell A12 from left side.

### How To Implement LEFT Function in Excel

Uses of Excel Functions Left Right in Excel Worksheet |

### First of all place the cursor in an empty cell next to cell A2, to enter the function.

- Type =
- Type the function name LEFT
- Type the left parenthesis (
- Type A2 from keyboard.
- Type , (that is Comma)
- Type 5 so that the first 5 characters will be returned from cell A2's text.
- Press Enter key (You need not to enter right parenthesis, it will be automatically included)
- The result
**Human**will be displayed in the cell.

**Humanity**.

Similarly, if we ignore the value of Number_of_characters then it is assumed to be 1 by default. So that the function LEFT(A2) will return only one character that is

**H**.

### Why To Use Right Function in Microsoft Excel?

The Right function is used to get the last N characters in a text string. Where N is the number of characters to be extracted from the given string.### Syntax of RIGHT Function in Excel

**RIGHT(Text, Number_of_characters)**

For example, the function Right("Night",2) will return

**ht**.

### Syntax of RIGHT function with Cell Reference

**RIGHT(CellReference, Num_of_char)**

For example, let the cell A2 contains the text

**Saturday**, the function

**RIGHT(A2,3)**will return

**day**.

### How To Implement RIGHT Function in Excel

First of all place the cursor in an empty cell next to cell A2, to enter the function.

- Type =
- Type the function name RIGHT
- Type the left parenthesis (
- Type A2 from keyboard.
- Type , (that is Comma)
- Type 3 so that the last 3 characters will be returned from cell A2's text.
- Press Enter key (You need not to enter right parenthesis, it will be automatically included)
- The result
**day**will be displayed in the cell.

- Num_of_char will be greater than zero normally.
- If Num_of_char is greater than the length of given text, then RIGHT function will return all of text.
- If the value of Num_of_char is not used then its default value 1 is used and only one last character is returned by the RIGHT function.

## Why To Use MID Function in Microsoft Excel?

The MID function is used to get the last N characters in a text string. Where N is the number of characters to be extracted from the given string.### Syntax of RIGHT Function in Excel

**MID(text, start_num, num_chars)**

For example, the function

**MID("Night",1,3)**will return

**Nig**.

### Syntax of RIGHT function with Cell Reference

**RIGHT(CellReference, start_num, num_chars)**

Where start_num is the number of starting character and num_chars is total number of characters to be extracted from the text.

For example, let the cell A2 contains the text

**Reservation**,

- the function
**MID(A2,6,3)**will return**vat**. - the function
**MID(A2,6,10)**will return**vation**. Since 10 is greater than the length of 6 th character to end of text, so this MID function will return all text starting from 6th character**v to last character n.** - the function
**MID(A2,1,1)**will return only one character starting from position 1 that is**R**.

### How To Implement RIGHT Function in Excel

First of all place the cursor in an empty cell next to cell A2, to enter the function.

- Type =
- Type the function name MID
- Type the left parenthesis (
- Type A2 from keyboard.
- Type , (that is Comma)
- Type 6
- Type ,
- Type 3 so that the 3 characters from position 6 will be returned cell A2's text.
- Press Enter key (You need not to enter right parenthesis, it will be automatically included)
- The result
**vat**will be displayed in the cell.

## 0 comments:

Post a Comment