|
LEN and LEFT are two text functions. LEN returns the length of a string. LEFT returns a number of characters from the start of a string.
Related, the RIGHT function returns a number of characters from the end of a string, and MID returns characters from the middle of a string. In the example below, =MID(B1,3,6) returns 123456, six characters, starting at position 3.
<-Previous (K)  Next (M)->
|
Blog