I need to search a text string, find 3 consecutive numbers in a row, then extract the first two characters. I have given an example below. The 3 consecutive numbers will always be between "-" but the occurrence of "-" will vary. The numbers also might be stored as text within the string. The text string will only be in B2. It is a part number and will be updated by the user every time. Any help is greatly appreciated.
<tbody>
</tbody>
<tbody> </tbody> | 56 | |
<tbody> </tbody> | 72 | |
<tbody> </tbody> | 96 | |
<tbody> </tbody> | 56 | |
<tbody> </tbody> | 60 | |
<tbody> </tbody> | 56 | |
<tbody> </tbody> | 36 | |
<tbody>
</tbody>