Function LEFT, MID, RIGHT
Function Left, Mid, and Right are the functions that used to take several characters from the data in Microsoft Excel starting from the left, center and right.
1. Fungi Left
Left function is a function used to take some of the characters of the data in Microsoft Excel starts from the left.
The general formula Left function is as follows:
= Left (text; num_char)
The purpose of the above formula are: text is where the data to be retrieved character, num_char is how the number of characters that we wish to take.
2. Mid Function
Mid function is a function used to take some of the characters of the data in Microsoft Excel starting from the middle.
The general formula Mid function is as follows:
= Mid (text; start_num; num_char)
The purpose of the above formula are: text is where the data to be retrieved character, star_num character is taken starting from how the character from the left, num_char is how the number of characters that we wish to take.
For example:
3. Functions Right
Right function is a function used to take some of the characters of the data in Microsoft Excel that is on the right.
The general formula Right function is as follows:
= Right (text; num_char)
The purpose of the above formula are: text is where the data to be retrieved character, num_char is is how the number of characters that we wish to take.
Examples:
Tag :
Office Skill
2 Komentar untuk "MS Excel LEFT, MID, RIGHT Formula"
Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.
Thks Salma 4 U comment