Note: 99 is just an arbitrary number that represents the longest word you oughta extract.
In the example shown, the calculated position is 366.
The MAX function is used to handle the problem of the substring appearing first in the text.
In that case, the position will be negative, and MAX is used to reset to 1.
For example, =MID(“apple”,2,3) returns “ppl”.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
When the text is not found, FIND returns a #VALUE error.
SUBSTITUTE Function
The Excel SUBSTITUTE function replaces text in a given string by matching.
For example, =REPT(“x”,5) returns “xxxxx”.
