Help Extracting Specific Text From Inconsistent Text Strings

Hello Excel Forum,

I'm Trying to Extracting Specific Text/Word From Inconsistent Text Strings while The Specific Text/Word have a format 4 letter words following with 5-7 Number. from one data cell the Inconsistent Text Strings it can be 1 or more Specific Text/Word need to extract inside separate column if possible.


Here the EX from my data set, while showing the result what i want if possible.



I'm hoping someone here can figure this out. Thank you so much for any help you can offer.