Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Generating a list of all possible number/letter combinations

I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?


---
Message posted from http://www.ExcelForum.com/

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Generating a list of all possible number/letter combinations

orion,

I have written an Excel add-in "Display Word Combinations". It should do
what you want...

All possible combinations for a series of characters are determined. (alpha
and or numeric)
Duplicate combinations are eliminated and a listing of the result is added
to the first empty column on the worksheet.
Valid words in the list are highlighted and shown at the top of the list.
It handles 3 to 8 character combinations and come with a one page Word.doc
install/use file.

It is available (for free) upon direct request. Remove the xxx from email
address.

Regards,
Jim Cone
San Francisco, CA
XX

"orion " wrote in message
...
I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Generating a list of all possible number/letter combinations

Sub tester1()
Dim i As Long, j As Long
Dim k As Long, ii As Long
Dim varr(1 To 36) As String
For i = 1 To 10
varr(i) = i - 1
Next
j = 11
For i = 65 To 90
varr(i - 54) = Chr(i)
Next i
ii = 0
For i = 1 To 36
For j = 1 To 36
For k = 1 To 36
ii = ii + 1
Cells(ii, 1).Value = "'" & varr(i) & _
varr(j) & varr(k)
Next
Next
Next
End Sub

--
Regards,
Tom Ogilvy


orion wrote in message
...
I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?


---
Message posted from http://www.ExcelForum.com/



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Generating a list of all possible number/letter combinations

Thank you so much Jim and Tom, you're brilliant!


---
Message posted from http://www.ExcelForum.com/

  #5   Report Post  
Junior Member
 
Posts: 1
Smile

Hi,

I saw you post in the ExcelBanter forum. [quote=Jim Cone;1014561]

I would appreciate a copy of your program to generate word combinations of 2, 3 and 4 letters.

I want to use it to search for the most common letter combinations in a 3000 word list.

To learn Morse code by hearing (not witting it) it is helpful to memorize 'letter combination sounds' rather than individual letters. It will be a great learning tool.

wb6mcw AT aol DOT com

Quote:
Originally Posted by Jim Cone View Post
orion,

I have written an Excel add-in "Display Word Combinations". It should do
what you want...

All possible combinations for a series of characters are determined. (alpha
and or numeric)
Duplicate combinations are eliminated and a listing of the result is added
to the first empty column on the worksheet.
Valid words in the list are highlighted and shown at the top of the list.
It handles 3 to 8 character combinations and come with a one page Word.doc
install/use file.

It is available (for free) upon direct request. Remove the xxx from email
address.

Regards,
Jim Cone
San Francisco, CA
XX

"orion " wrote in message
...
I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating Possible Combinations and Assigning ID Number Joe Kluck Excel Worksheet Functions 2 March 28th 10 10:58 PM
generating random number list yvette Excel Worksheet Functions 1 January 12th 07 06:07 PM
How do i set up a list that sorts as Number/letter/number in orde xorex Excel Discussion (Misc queries) 3 September 8th 06 12:59 AM
Generating excel combinations mark4006 Excel Discussion (Misc queries) 2 March 6th 05 05:40 PM
Function generating all possible combinations of set of numbers Lucia Excel Worksheet Functions 1 February 7th 05 11:41 PM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"