Please look at this logic
ARCHAEA
ALTHAEA
TAIAHAS
MANAIAS
WAIATAS
Say those are on A1
Need formula on b1 drag down to give below
AEA
AEA
AIA
AIA
AIA
Need formula to search 3 consecutive vowels in the word and pull that at B
Find file attached , with expected results for the first 5 words
Thank you
Bookmarks