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

char()
 

=char(row()+96)&row()

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()

char()
 

so near yet so far...:)...10s! Jarek kujawa.....much appreciated

thanks community as well

:)
--
oldLearner57


"Jarek Kujawa" wrote:

=char(row()+96)&row()

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()