Fill Series... Letters? Can Someone Help?
 

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

I'm not quite sure if I understand, but I put this in B1 and dragged down.

=" "&CHAR(MOD(ROW()-1,26)+65)

I got A-Z repeated every 26 rows.

But maybe putting this formula in B1 and dragging down would be nicer:

=A1&" "&CHAR(COUNTIF($A$1:A1,A1)+64)





Greegan wrote:

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

--

Dave Peterson

Greegan

Once you have A through Z in 26 cells, copy the cells then go to
ToolsOptionsCustom Lists and import to there.

Next time you nedd A to Z just enter A in a cell then drag down.

Gord Dibben Excel MVP

On Sun, 12 Dec 2004 16:50:28 -0600, Dave Peterson
wrote:

I'm not quite sure if I understand, but I put this in B1 and dragged down.

=" "&CHAR(MOD(ROW()-1,26)+65)

I got A-Z repeated every 26 rows.

But maybe putting this formula in B1 and dragging down would be nicer:

=A1&" "&CHAR(COUNTIF($A$1:A1,A1)+64)





Greegan wrote:

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