This position, minus one, is fed into the LEFT function asnum_chars.

Handling one word

If a cell contains only one word, this formula returns an error.

For example, =LEFT(“apple”,3) returns “app”.

Excel formula: Extract nth word from text string

When the text is not found, FIND returns a #VALUE error.

Excel formula: Extract word that begins with specific character

Excel formula: Split text string at specific character

Excel formula: Abbreviate names or words

Excel formula: Split text with delimiter

Excel LEFT function

Excel FIND function

Excel ISERROR function