Serial number

Closed
mahesh - 16 Nov 2010 à 00:58
dkalimuthu Posts 2 Registration date Wednesday 17 November 2010 Status Member Last seen 17 November 2010 - 17 Nov 2010 à 01:35
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


Related:

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.
dkalimuthu Posts 2 Registration date Wednesday 17 November 2010 Status Member Last seen 17 November 2010
17 Nov 2010 à 01:35
nothing to worry mahesh, just drag the cell using mouse .. u l get answer