Consonant Vowel convert words to CVCV

[forma]

Hi! Trying to figure out the formula to convert simple words to consonant vowel consonant format.

cat-->CVC
mama--->CVCV


I found this formula but it only gives me the first letter.

=IF(ISERROR(MATCH(A2,{"A";"E";"I";"O";"U"},0)),"C","V")

Thanks!

 

[pgc01]

Hi Peter

You could also use Concat(), which is TextJoin() without the first 2 parameters.

 

[Peter_SSs]

Hi Peter

You could also use Concat(), which is TextJoin() without the first 2 parameters.

You certainly could pgc - and should
Somebody mentioned TEXTJOIN - so I just went right along with that.

So for completeness, that would be

=CONCAT(IF(ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"aeiou")),"V","C"))

confirmed with C+S+E