+ Reply to Thread
Results 1 to 2 of 2

combination of numbers or letters

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    tunisia
    MS-Off Ver
    Excel 2010
    Posts
    1

    combination of numbers or letters

    Hi
    I am new to your wonderful forum, I love all your programs and I was moved by your performance.
    I am a student, I have a problem in which I seek a solution lot, I really tried but I could not solve it and I want you to help me to find a solution
    So I want EXCEL program that can do all of the possibilities (combinations) possible with the letters a, b, c in character strings composed by 13 elements (elements are a, b and c, that's all, no more)
    then the result is 2,197 strings of 13 letters written by these three letters only, for example:
    aaaaaaaaaaaaa
    abcabcabcabca
    aaaaabbbbbccc
    aabbccaabbcca
    .
    .
    .
    .
    .
    .
    .
    etx
    and Thank you in advance

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,873

    Re: combination of numbers or letters

    Unfortunately, your estimation is wrong, You will get 1 594 323 different strings, so more than excel can fit in one column.

    But you can start and see first few (or more

    write in A1 formula:
    Please Login or Register  to view this content.
    copy it into next 12 columns and then copy all 13 columns some rows down.

    to have letters in one string use in N1:

    Please Login or Register  to view this content.
    (of course write all cells in ...)

    and copy down
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Removing letters from text & letters combination
    By benoj2005 in forum Excel General
    Replies: 5
    Last Post: 02-26-2014, 11:20 AM
  2. Sum numbers with certain combination of letters
    By sizcorx in forum Excel General
    Replies: 1
    Last Post: 10-09-2010, 09:10 PM
  3. Replies: 0
    Last Post: 04-03-2006, 07:25 PM
  4. finding out the combination of letters!
    By via135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2006, 01:12 AM
  5. [SOLVED] random combination of letters
    By rp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-16-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1