Extracting combinations of letters from within a word

[vicmtl]

Hello!

I'm working on creating a list of possible combinations of consonants in words in a variety of languages. I have 60,000 enties such as "sVltVd" (where "V" was used to replace any vowel; so the word in brackets was actually the English word "salted").

I need to extract into an adjacent column all combinations of consonants that are between two "V"s and only when there are 2 or more consonants in a row.

For example, the result for "sVltVd" should be "lt". For "VtVmkVrV", the result should be "mk".

Also, some words have 2-3 such combinations within a word, such as "pVstVmnVVl", so in this case the result should be "st" and "mn" (they can be in different columns or in the same cell but separated with a comma, etc).

Is there any formula I can use to do this?

Thanks,
Vic

[rylo]

Vic

Easiest way I can think to do this is to build your own function.

Put the code below into a general module attached to the workbook.

Please Login or Register  to view this content.

Say your data starts in A1, then enter the formula

=concomb(A1)

and copy down.

HTH

rylo

[vicmtl]

rylo,

You are amazing! It worked just the way I needed it to work and it'll save me quite a few days of tedious manual labour!

Thanks,
Vic