Deep,

Sorry, a small mistake in my original post, the ouput to be in B1, C1, D1.

Also the formula you posted extracts every 6 text strings into the cell, I want only to extract ALEX and not FRED.

Can you still help me.