Functions that will be discussed this time is a function string. The string functions are used to retrieve, modify, sell or put the contents.
Usually this string functions closely related to text data in excel. Overview of the function of this string is not important, but it is also quite useful.
Moreover, if there is a code, and this srting function in combination with the function If it will be more useful, for example, just to make a short code (x) the first letter or (x) the number of letters behind a word or name.
Here are some types of string functions:
String Functions for Taking Characters Left at Home Words
- Function Left
= LEFT (source cell address; The number of characters to be taken)
For example, you write CHARLIE in cell A1. Then you write LEFT (A1; 4) in cell C1, it would appear CHAR.
- Right function
Just as the function of the left, the difference between this function only to retrieve data from a right data. The syntax of the function right is
= RIGHT (source cell address; the number of characters that will be taken)
For Examples are CHARLIE on the cell A1. Then you write = RIGHT (A1; 4) in cell C1 then the result is RLIE.
- Mid function
Mid function is useful for retrieving data from a cell source of the center.
= MID (source cell address; the initial character to be taken; the number of characters that will be taken) is the syntax of the function of this mid.
write CHARLIE in cell A1, and enter the function = MID (A1; 2; 4) in another cell, it would appear HARL. Functions that you entered earlier explained grab character in cell A1 starting from the second character, in this case means A, a total of 4 characters.
Enough of this lesson for Using Letter Front or Rear Name to Code with Excel. and hopefully usefull for all of you.
0 komentar:
Posting Komentar