LEFT function in Microsoft Excel

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:

Posted in: Excel, LEFT function, Microsoft