Search Substring within column of text strings and list multiple results

I have applied a formula to search a substring within an array. Formula is producing results, though not all matches are appearing as result. I have tried the usual traps, spaces, formats...etc. Still cant figure out why only partial results are being listed. Would appreciate assistance on this.

Thanking you in advance.