Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? . |
#3
![]() |
|||
|
|||
![]()
Erin
Would a custom format work for you? FormatCellsNumberCustom type in ###0"-s" Gord Dibben Excel MVP On Thu, 31 Mar 2005 13:11:01 -0800, "Erin" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |