How to create text lists like "all possible 4 letter wo

marcel33

New Member
Joined
Jul 14, 2006
Messages
10
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
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
In cell B2 use the formula

=$A2&B$1

and copy across and down

edit: to keep just one capital letter make it

=PROPER($A2&B$1)
 

marcel33

New Member
Joined
Jul 14, 2006
Messages
10
OK. I found a way to get rid of the table and have one list of words.

1. on excel copy the whole table (excluding first row and first column obviously)
2. Paste to notepad (this will clear text formats)
3. Copy everything from notepad and paste to MS Word.
4. Select all on ms word and click on the top menu "table>convert>text to table" and edit number of columns to 1
5. While the table is stil highlited, on the menu choose "table>convert >table to text" and click OK.
6. 217 pages on a word document arent very good so select all and and copy it to a txt file.

Thats it.

Thank you for your help. I'm very happy with this forum.
 

Forum statistics

Threads
1,136,613
Messages
5,676,813
Members
419,652
Latest member
jjakub33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top