FUNCTION CATALOGUE / TEXT
LEFT Excel function
Returns characters from the start of text.
Correct sentence to use
Extract the first [number] characters from [text].
Modify this query in PlainFormula →Example formula
=LEFT(A2,3)
Returns characters from the left.
Syntax
LEFT(text, [num_chars])
Argument signature: text, [num_chars]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.