Serial number

[Closed]
Report
-
Posts
2
Registration date
Wednesday November 17, 2010
Status
Member
Last seen
November 17, 2010
-
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 replies

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
2
Registration date
Wednesday November 17, 2010
Status
Member
Last seen
November 17, 2010

nothing to worry mahesh, just drag the cell using mouse .. u l get answer