Explanation
Overview
The formula looks complex, but the mechanics are in fact quite simple.
when you land the position, you might use other functions to extract what you need.
Since the array constant contains 10 numbers, the result will be an array with 10 values.
As long as a numberdoesappear in the original text, that position will be returned.
When the text is not found, FIND returns a #VALUE error.
MIN Function
The Excel MIN function returns the smallest numeric value in the data provided.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
For example, =RIGHT(“apple”,3) returns “ple”.
For example, =LEFT(“apple”,3) returns “app”.
Related videos
How to create a complex formula step by step
