Actually the list I really need is a little different than what the title says.
I need a list of all possible 4 letter "consonant, vowel, consonant,vowel" combinations.
In other words if
1. "cvcv" is a 4 letter word,
2. c (for consonants) can be anything between b,c,d,f,g,h,j,k,l,m,n,p,q,r,s,t,v,w,x,y,z
3. and v (for vowel) can be anything between a,e,i,o,u
Than what are all the possible combinations for these 4 letter words.
There should be 21*5*21*5= 11.025 words.
The lists will start as baba, baca, bada end will end as zuxu, zuyu, zuzu.
The question is, how do I create the list of those 11.025 words with excel? Can I?
Probably there are better ways but I tried the following strategy but don't know how do proceed. I created manually a list of all cv (consonant vowel) combinations. There are 105 of them. Then I created a column and a row with those 105. If I can find a way to add texts together and fill the whole table then 105*105 is exactly 11.025 and I should have a whole list.
Can you please help to solve this. Thank you so much.
Here is a screenshot of what I'm trying to do:
http://img170.imageshack.us/img170/4694/cvlsfu9.jpg
Here are the 105 cv combinations:
Ba
Be
Bi
Bo
Bu
Ca
Ce
Ci
Co
Cu
Da
De
Di
Do
Du
Fa
Fe
Fi
Fo
Fu
Ga
Ge
Gi
Go
Gu
Ha
He
Hi
Ho
Hu
Ja
Je
Ji
Jo
Ju
Ka
Ke
Ki
Ko
Ku
La
Le
Li
Lo
Lu
Ma
Me
Mi
Mo
Mu
Na
Ne
Ni
No
Nu
Pa
Pe
Pi
Po
Pu
Qa
Qe
Qi
Qo
Qu
Ra
Re
Ri
Ro
Ru
Sa
Se
Si
So
Su
Ta
Te
Ti
To
Tu
Va
Ve
Vi
Vo
Vu
Wa
We
Wi
Wo
Wu
Xa
Xe
Xi
Xo
Xu
Ya
Ye
Yi
Yo
Yu
Za
Ze
Zi
Zo
Zu
I need a list of all possible 4 letter "consonant, vowel, consonant,vowel" combinations.
In other words if
1. "cvcv" is a 4 letter word,
2. c (for consonants) can be anything between b,c,d,f,g,h,j,k,l,m,n,p,q,r,s,t,v,w,x,y,z
3. and v (for vowel) can be anything between a,e,i,o,u
Than what are all the possible combinations for these 4 letter words.
There should be 21*5*21*5= 11.025 words.
The lists will start as baba, baca, bada end will end as zuxu, zuyu, zuzu.
The question is, how do I create the list of those 11.025 words with excel? Can I?
Probably there are better ways but I tried the following strategy but don't know how do proceed. I created manually a list of all cv (consonant vowel) combinations. There are 105 of them. Then I created a column and a row with those 105. If I can find a way to add texts together and fill the whole table then 105*105 is exactly 11.025 and I should have a whole list.
Can you please help to solve this. Thank you so much.
Here is a screenshot of what I'm trying to do:
http://img170.imageshack.us/img170/4694/cvlsfu9.jpg
Here are the 105 cv combinations:
Ba
Be
Bi
Bo
Bu
Ca
Ce
Ci
Co
Cu
Da
De
Di
Do
Du
Fa
Fe
Fi
Fo
Fu
Ga
Ge
Gi
Go
Gu
Ha
He
Hi
Ho
Hu
Ja
Je
Ji
Jo
Ju
Ka
Ke
Ki
Ko
Ku
La
Le
Li
Lo
Lu
Ma
Me
Mi
Mo
Mu
Na
Ne
Ni
No
Nu
Pa
Pe
Pi
Po
Pu
Qa
Qe
Qi
Qo
Qu
Ra
Re
Ri
Ro
Ru
Sa
Se
Si
So
Su
Ta
Te
Ti
To
Tu
Va
Ve
Vi
Vo
Vu
Wa
We
Wi
Wo
Wu
Xa
Xe
Xi
Xo
Xu
Ya
Ye
Yi
Yo
Yu
Za
Ze
Zi
Zo
Zu