If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I set up a series with letters and numbers together?
I am using Excel 2003. I am trying to set up a series of claim numbers they
look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
#2
|
|||
|
|||
How can I set up a series with letters and numbers together?
Enter the first two entries
Highlight the two entries Drag the little square (at the bottom right of your selection) down to as many is needed Excel should continue the series you started. "Nommer" wrote: I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
#3
|
|||
|
|||
How can I set up a series with letters and numbers together?
Thanks. That worked perfectly
"Sloth" wrote: Enter the first two entries Highlight the two entries Drag the little square (at the bottom right of your selection) down to as many is needed Excel should continue the series you started. "Nommer" wrote: I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
#4
|
|||
|
|||
How can I set up a series with letters and numbers together?
Nommer
A kind of shortcut to Sloth's method. Enter the first entry in a cell. Right-click and drag down. Release button and select "Fill Series" Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 07:42:01 -0700, Nommer wrote: Thanks. That worked perfectly "Sloth" wrote: Enter the first two entries Highlight the two entries Drag the little square (at the bottom right of your selection) down to as many is needed Excel should continue the series you started. "Nommer" wrote: I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
#5
|
|||
|
|||
How can I set up a series with letters and numbers together?
I used to use this method to fill; however, it is no longer working for me in
Excel 2003. I wanted to auto-fill from 181A to 181Z and entered the first 4 cells. After highlighting cells 181A to 181D and dragging the little square down, all I received was 181A to 181D in repeats. Can you help please? "Sloth" wrote: Enter the first two entries Highlight the two entries Drag the little square (at the bottom right of your selection) down to as many is needed Excel should continue the series you started. "Nommer" wrote: I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
#6
|
|||
|
|||
How can I set up a series with letters and numbers together?
On Sep 18, 12:08 pm, Gi wrote:
I used to use this method to fill; however, it is no longer working for me in Excel 2003. I wanted to auto-fill from 181A to 181Z and entered the first 4 cells. After highlighting cells 181A to 181D and dragging the little square down, all I received was 181A to 181D in repeats. Can you help please? They seem to have removed that functionality. They have also removed the alphabet as a standard list. It works if the number is last, but not letters. If it is a frequently used series, you can add it yourself in the Options:Custom Lists dialog box. Then it will work, but only for that specific combination. If you have various similar series that you use, it won't work for them. You'd have to add each series. Maybe that would be worth it to save time later. |
#7
|
|||
|
|||
How can I set up a series with letters and numbers together?
In A1 enter ="181" & CHAR(ROW(A65))
Copy down to A26 Gord Dibben MS Excel MVP On Thu, 18 Sep 2008 10:08:01 -0700, Gi wrote: I used to use this method to fill; however, it is no longer working for me in Excel 2003. I wanted to auto-fill from 181A to 181Z and entered the first 4 cells. After highlighting cells 181A to 181D and dragging the little square down, all I received was 181A to 181D in repeats. Can you help please? "Sloth" wrote: Enter the first two entries Highlight the two entries Drag the little square (at the bottom right of your selection) down to as many is needed Excel should continue the series you started. "Nommer" wrote: I am using Excel 2003. I am trying to set up a series of claim numbers they look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a fast way for me to create a series in excel for this list of claims instead of just entering them all in one by one? |
Thread Tools | |
Display Modes | |
|
|