Data fill question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Would a custom format work for you?

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


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Auto fill column with sequential numbers with decimals 2
Displaying zeros in cells 2
filtering question.... 1
Last Modified By in a cell by user 3
Calculate (Auto Fill) cells with numbers and text. 3
Fill without formatting 1
Auto fill numbers starting with zero 3

Back
Top