to number the rows in Sequential order

[shanmp]

hi all,
I m new to this forum, i need a help regarding numbering the rows,
For example
If there is a row sequence 1
2
3
4 u can just drag by entering two series it will continue..
But when the case is like
a_1_s
r_2_g
t_3_h
here how it can b implemented ?
My doubt is to sequence only the number not the alphabets

[oldchippy]

Hi,

From your example I'm assumming you have a column of alphanumeric data in column A? If so you could try this in B1 and copy down

=LEFT(A1,2)&ROW()&RIGHT(A1,2)

[oldchippy]

Hi again,

If you wanted sequential numbers and random letters, you could try,

=CHAR(RANDBETWEEN(97,122))&CHAR(95)&ROW()&CHAR(95)&CHAR(RANDBETWEEN(97,122)) copy down