You could use a formula. With the first cell filled in
(like A1), put this in A2 and fill down:
=(LEFT(A1,FIND("-",A1)-1)+1)&"-s"
HTH
Jason
Atlanta, GA
-----Original Message-----
Hi all,
How do I do an auto fill on a certain amount of cells in
a range of numbers
but at the end of the number there is a dash s. For
example: 343-s,
344-s,345-s and so on. I tried to do the auto fill but
it is just repeating
the sequence of numbers?
.
|