Loading…
Loading…
LEN counts characters. LEFT returns characters from the start of text and RIGHT from the end. Combine them, e.g. LEFT(A2,LEN(A2)-2) drops the last two characters.
Syntax
LEN(text) · LEFT(text, [num_chars]) · RIGHT(text, [num_chars])
Read the lesson, then try it yourself in a live spreadsheet.