The syntax for this function is below: Where array refers to the data range from which you want to extract ... come across in ...

In “Save time by using Excel’s Left, Right, and Mid string functions,” we showed you how to extract substrings from the left, right, or middle of a string with a fixed number of characters.