Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In our list of addresses we have a code which will identify each individual
address (some are listed by names, but some are listed by a numeric account). Within these lists can be this "finders code" with the same number, yet we need to identify each as a unique person or account. In most cases the numbers don't reoccur more than 10 times but I want to find a fast way of adding some sort of identifier. So this is what I want to do Say we have in column A a list of customers which have numeric values 1001 through 5001, and some numbers repeat themselves. I would have already sorted column A. Now I want to add letters A through Z and repeat. I also want a space before the letter. The only way I can do this (since I'm not seeing an option) is insert column B and enter A through Z and copy/paste at the end of the list and then concatenate the two columns. Is there a way to Fill a SERIES or alpha characters like it does with numeric values? If someone is able to tell me how I can do this. If you have a module that will do this, great. thanks in advace. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto fill series | Excel Discussion (Misc queries) | |||
fill a particular cell on a series of worksheets from a lookup tab | Excel Discussion (Misc queries) | |||
How do I fill down formulas so they iterate in intervals other th. | Excel Worksheet Functions | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
Excel Fill Series | Excel Discussion (Misc queries) |