Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
char()
hi community
got the char() from community assist and I tried to create a running alphabetically order from a - z, however, I tried to join a number with it... =char(row()+96)&1 with the above, when I dragged down I will get .... a1 b1 c1 ...... what I wish to have be like a1 b2 c3 ......... how can I add the series number with the alphabet? thanks community again for kind assistance thanks -- oldLearner57 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
char()
=char(row()+96)&row()
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
char()
"oldLearner57" wrote in message
... hi community got the char() from community assist and I tried to create a running alphabetically order from a - z, however, I tried to join a number with it... =char(row()+96)&1 with the above, when I dragged down I will get .... a1 b1 c1 ..... what I wish to have be like a1 b2 c3 ........ how can I add the series number with the alphabet? thanks community again for kind assistance thanks -- oldLearner57 =char(row()+96)&row() |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
char()
so near yet so far...:)...10s! Jarek kujawa.....much appreciated
thanks community as well :) -- oldLearner57 "Jarek Kujawa" wrote: =char(row()+96)&row() |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
char()
10s! chris for the so simple task yet so much difficult for me :)
much appreciated thanks community as well :) -- oldLearner57 "Chris" wrote: "oldLearner57" wrote in message ... hi community got the char() from community assist and I tried to create a running alphabetically order from a - z, however, I tried to join a number with it... =char(row()+96)&1 with the above, when I dragged down I will get .... a1 b1 c1 ..... what I wish to have be like a1 b2 c3 ........ how can I add the series number with the alphabet? thanks community again for kind assistance thanks -- oldLearner57 =char(row()+96)&row() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
char 124 where is on my keyboard. | Excel Discussion (Misc queries) | |||
FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
Counting char help | Excel Worksheet Functions | |||
CHAR(10) | Excel Worksheet Functions |