Data fill question

E

Erin

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

Jason Morin

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
 
G

Gord Dibben

Erin

Would a custom format work for you?

Format>Cells>Number>Custom type in ###0"-s"


Gord Dibben Excel MVP
 
Top