LEFT function
Left function is used to retrieve characters from the left in the string. Formula / basic formula of the function is left ... ..
= LEFT (String, X) / / = LEFT (cell address, X) or
= LEFT (String; X) / / = LEFT (cell address; X)
Description:
String: words / strings, or cells that would have taken his character
X: The number of characters is taken.
For example:
= LEFT ("Yogyakarta", 5) - Enter - result: Yogya
= LEFT ("technology", 4) - Enter - result: Tech
What if using a table in Excel as shown below:
Left function is used to retrieve characters from the left in the string. Formula / basic formula of the function is left ... ..
= LEFT (String, X) / / = LEFT (cell address, X) or
= LEFT (String; X) / / = LEFT (cell address; X)
Description:
String: words / strings, or cells that would have taken his character
X: The number of characters is taken.
For example:
= LEFT ("Yogyakarta", 5) - Enter - result: Yogya
= LEFT ("technology", 4) - Enter - result: Tech
What if using a table in Excel as shown below:
