LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Greegan
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto fill series Dave Excel Discussion (Misc queries) 2 January 19th 05 05:54 PM
fill a particular cell on a series of worksheets from a lookup tab br549 Excel Discussion (Misc queries) 1 January 7th 05 12:42 AM
How do I fill down formulas so they iterate in intervals other th. picklet222 Excel Worksheet Functions 2 December 18th 04 01:23 PM
fill series grayed out (not available, disactivated) Michel Dion (from IMS Health in Canada) Excel Discussion (Misc queries) 1 December 17th 04 02:35 AM
Excel Fill Series electromott Excel Discussion (Misc queries) 2 December 16th 04 02:55 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"