Item descriptions can be very long and confusing, so you're still interested in extracting specific parts of the character sequence. Excel has three functions for this purpose: LEFT, RIGHT, and MID . These formulas are already very interesting on their own, but in combination with FIND they develop their full potential. We start from the basis that your denominations always follow a certain pattern, which is made up of letters, numbers and hyphens: ABCDE-A-12345-T.
Let's say you want to extract the numeric part in the middle, but since the character sequence does not have a certain length , the normal functions to extract will not be very useful. These functions are based on a certain number of characters, a piece of information that, in this case, you cannot provide. However, thanks to the dashes, the FIND function can be useful, as this function will give you the position indication you need.
As several hyphens appear in the sequence of characters, you must perform a nesting of the FIND function . In this example, we assume that the numeric part always spans five characters.