Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 04, 08:47 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
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  
Old January 8th 04, 09:24 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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
news
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  
Old January 9th 04, 01:00 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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
news
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  
Old January 9th 04, 02:10 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
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  
Old November 27th 16, 10:36 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
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
news
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 05: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 04:40 PM
Function generating all possible combinations of set of numbers Lucia Excel Worksheet Functions 1 February 7th 05 10:41 PM


All times are GMT +1. The time now is 09:44 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017