RE: Alphabetic autofill

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kassie <Kassie@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 15:15:03 -0700

Hi dogisnuts

You can use the following formula, previously posted by Max

=UPPER(IF(ROW(A1)>18278,CHAR(96+INT(MOD(ROW(A1)-18279,456976)/17576)+1),"")&
IF(ROW(A1)>702,CHAR(96+INT(MOD(ROW(A1)-703,17576)/676)+1),"")&IF(ROW(A1)>26,
CHAR(96+INT(MOD(ROW(A1)-27,676)/26)+1),"")&CHAR(97+MOD(ROW(A1)-1,26)))

"dogisnuts" wrote:

> I want Excel to autofill our inventory system. It is alphabetic though.
> AAA, AAB,...-ZZZ. I understand that you have to build a macro to do it. Any
> suggestions?
>
> Thank you
.

References:
- Alphabetic autofill
  - From: dogisnuts

Prev by Date: Re: Seeing Protected Cells
Next by Date: default settings under alignment tab in Excel
Previous by thread: Re: Alphabetic autofill
Next by thread: how to add a letter in front of each number in a cell
Index(es):
- Date
- Thread

Relevant Pages

Re: pay scale formula
... In Excel, you would just type in two of the amounts at ... type $160.00 twice and then drag to AutoFill. ... I have looked at the help section and dont quite ...
(microsoft.public.word.tables)
RE: rename fields in queries
... In Excel using the autofill create your list like this for the 180 colomns. ... click in cell B3 and Paste Special – ... using the date summation functions of Access. ...
(microsoft.public.access.queries)
Re: Autofill using a custom series with a macro
... Microsoft MVP - Excel ... > I have a userform that prompts a user to select certain values. ... > a custom series that I have specified. ... > autofill continuing the series, ...
(microsoft.public.excel.worksheet.functions)
Re: Auto fill?
... I am not sure for the command MERGE because I use a Swedish excel but it ... You can autofill down a contiguous column by double-clicking the little ... I am importing some data from a database to excel and is using some ...
(microsoft.public.excel.misc)
Conditional formulas between multiple worksheets
... I want excel to autofill a formula across a range of cells. ... this formula changes the cell values for the ... but it also changes the inputs for the logical tests ...
(microsoft.public.excel.worksheet.functions)