Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number to equivalent Letter
I need a spreadsheet with the following data: (in either format)
Format 1: col 1 col 2 col3 a a a a a b a a c a a d ... z z z format 2: col1 aaa aab aac aad ... zzz This spreadsheet will go on to list ALL the 17,000+ permutations. Is there a formula or something that can either: 1. create the list automatically using the letters? 2. if i used numbers in format 1, is there a formula to convert the number to it's equivalent letter ? 1=a, 2=b, c=3 etc. Thanks for looking. Ann |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number to equivalent Letter
In A703, enter:
=IF(ROW()18277,CHAR(64+MOD(INT((ROW()-18279)/17576),26)+1),"")& IF(ROW()702,CHAR(64+MOD(INT((ROW()-703)/676),26)+1),"")& IF(ROW()26,CHAR(64+MOD(INT((ROW()-27)/26),26)+1),"")& CHAR(64+MOD(ROW()-1,26)+1) and copy down -- Gary''s Student - gsnu200841 "Ann" wrote: I need a spreadsheet with the following data: (in either format) Format 1: col 1 col 2 col3 a a a a a b a a c a a d ... z z z format 2: col1 aaa aab aac aad ... zzz This spreadsheet will go on to list ALL the 17,000+ permutations. Is there a formula or something that can either: 1. create the list automatically using the letters? 2. if i used numbers in format 1, is there a formula to convert the number to it's equivalent letter ? 1=a, 2=b, c=3 etc. Thanks for looking. Ann |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number to equivalent Letter
Here's another way, entered in Row 1:
=CHAR((INT((ROW()-1)/676)+1)+96)&CHAR((MOD(INT((ROW()-1)/26),26)+1)+96)&CHAR((MOD(ROW()-1,26)+1)+96) Copy down... HTH Elkar "Ann" wrote: I need a spreadsheet with the following data: (in either format) Format 1: col 1 col 2 col3 a a a a a b a a c a a d ... z z z format 2: col1 aaa aab aac aad ... zzz This spreadsheet will go on to list ALL the 17,000+ permutations. Is there a formula or something that can either: 1. create the list automatically using the letters? 2. if i used numbers in format 1, is there a formula to convert the number to it's equivalent letter ? 1=a, 2=b, c=3 etc. Thanks for looking. Ann |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number to equivalent Letter
Hi,
Enter the following formula anywhere on row 1 and copy it down. =CHAR(ROW()/676+64.999)&CHAR(ROW()/26+64.97)&CHAR(MOD(ROW()-1,26)+65) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Ann" wrote: I need a spreadsheet with the following data: (in either format) Format 1: col 1 col 2 col3 a a a a a b a a c a a d ... z z z format 2: col1 aaa aab aac aad ... zzz This spreadsheet will go on to list ALL the 17,000+ permutations. Is there a formula or something that can either: 1. create the list automatically using the letters? 2. if i used numbers in format 1, is there a formula to convert the number to it's equivalent letter ? 1=a, 2=b, c=3 etc. Thanks for looking. Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
change headers from letter to number/number to letter | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Can you convert a number to word equivalent ? | Excel Worksheet Functions |