Serial number

Closed
mahesh - Nov 16, 2010 at 12:58 AM
dkalimuthu Posts 2 Registration date Wednesday November 17, 2010 Status Member Last seen November 17, 2010 - Nov 17, 2010 at 01:35 AM
Hello,

i want to use formula for adding serial number which contains text also, for example

MAH10001
MAH10002
I Want in next row it will be MAH10003

thanks
mahesh


2 responses

Highlight both the cells containng the first to entries, then drag down using the drag handle (the little black square at the bottom right of the highlighted selection). Drag as far as you want and Excel will do the rest for you.
1
dkalimuthu Posts 2 Registration date Wednesday November 17, 2010 Status Member Last seen November 17, 2010
Nov 17, 2010 at 01:35 AM
nothing to worry mahesh, just drag the cell using mouse .. u l get answer
0