Autofill alphanumeric prefix in Excel


S

steppingup09

I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1.

Thanks
 
Ad

Advertisements

C

Claus Busch

Hi,

Am Wed, 16 Apr 2014 10:53:35 -0700 (PDT) schrieb (e-mail address removed):
I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1.
in row 1:
="a"&ROW()

If you start from another row then
="a"&ROW(A1)


Regards
Claus B.
 
S

steppingup09

I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1. Thanks

Claus - Thank you for your answer. It works fabulously! :)
 
Ad

Advertisements

Joined
Dec 9, 2017
Messages
1
Reaction score
0
I have a similar issue. My job involves a number of prefixes used for different items. These prefixes are created by a program specifically for this purpose.

The prefixes consist of four alphanumeric chapters on an ascending cycle from 0-9 and continuing with A-Z. EG: 0,1,2...8,9,A,B... and must be all caps. One may look like 5NB2 or DT3A, just to lend a visual. Much of the current practice is mind-numbingly tedious, as you can imagine.

We are well into the cycling and I want to create two sets of columns, or one longer column, so that I only need to enter the first in a new sequence to accurately complete the sequence either automatically or by dragging. Rather than c/p 80 of them one by one.

Can this be done as well? If so, please show me how I can set this up. Thank you!
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill data based on an assigned code/prefix 2
Alphanumeric 1
Prefix 4
ALPHANUMERIC 5
Autofill - Excel 7
Alphanumeric 22
Highest alphanumeric 6
Alphanumeric limitation 11

Top