View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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?
.