LEFT(text [,num_chars])

Returns the first or left most characters in a text string.

textThe text string that contains the characters you want to extract.
num_chars(Optional) The number of characters you want to extract.


* If "text" is a text string then it must be enclosed in speech marks.
* The "text" can be numbers.
* The "text" can be a cell reference.
* If "num_chars" < 0, then #VALUE! is returned.
* If "num_chars" > the length of the "text", then "text" is returned.
* If "num_chars" is left blank, then 1 is used.
* Any blank spaces are counted as individual characters.
* If more than one cell is referenced then a Dynamic Array Formula will be applied.
* You can use the RIGHT function to return the last or right most characters in a text string.
* You can use the TRIM function to return a text string with all spaces removed from the beginning, middle and end.
* You can use the LEFTB function if you have languages that use the double-byte character set.
* For the Microsoft documentation refer to support.microsoft.com

1=LEFT("Better Solutions",6) = Bettersome text
2=LEFT("Better",1) = Bmore
3=LEFT("Better",0) = blanktext
4=LEFT("Solutions") = S 
5=LEFT("Be More Productive",7) = Be More 
6=LEFT("Be More Productive",100) = Be More Productive 
7=LEFT(" word",5) = " word" 
8=LEFT(TRIM(" word"),5) = word 
9=LEFT(12345,2) = 12 
10=LEFT(B1,4) = some 
11=LEFT(B1:B3,4) = { some , more , text } 
12=LEFT("Better Solutions",-5) = #VALUE! 
13=LEFT("Better Solutions","Be More Productive") = #VALUE! 

11 - This is an example of the function returning a dynamic array formula

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top