| 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 |
| 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 | |||
Threaded Mode
