However, it is possible to calculate positions with theFIND functionandSEARCH function.
See links below for examples.
For example, =MID(“apple”,2,3) returns “ppl”.
Extract substring
To extract a substring with an Excel formula, you can use the MID function. In the example shown, the formula in E5 is: =MID(B5,C5,D5-C5+1) which, on row 5, returns "Perfect".
