The resulting string is returned to the FIND function, configured to look for “#”.

Since the “#” is the 12th character in the text, FIND returns 12.

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

Excel formula: Split text string at specific character

SUBSTITUTE Function

The Excel SUBSTITUTE function replaces text in a given string by matching.

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

Excel formula: Split text and numbers

Excel formula: Split dimensions into two parts

Excel formula: Get first word

Excel formula: Get last word

Excel formula: Split text with delimiter

Excel LEFT function

Excel SUBSTITUTE function

Excel FIND function