Solved

Auto increment alphanumeric field

Posted on 2015-02-10
2
140 Views
Last Modified: 2015-02-10
I need to auto-increment an alphanumeric value in cell b2.  The value in cell b2 is: A000001

In cell b3 I want this: A000002
In cell b4 I want this: A000003
etc...
In cell b9 I want this: A000010
etc..

What formula can I use to increment an alphanumeric value like this?

Thanks for any help.
0
Comment
Question by:-Dman100-
2 Comments
 
LVL 4

Accepted Solution

by:
deanomac earned 250 total points
ID: 40600790
Would selecting the cell A000001, click and hold on the little square at the bottom right of the cell and dragging down the column not solve that?

Just tested in in Excel 2013 and it left the A but added 1 to each number going down.
0
 
LVL 26

Assisted Solution

by:Shaun Kline
Shaun Kline earned 250 total points
ID: 40600797
If the fill down mentioned by deanomac is not to your liking, try this formula in b3:
=LEFT(B2, 1) &  RIGHT("000000" & NUMBERVALUE(MID(B2, 2, LEN(B2)-1)) + 1, 6)

Open in new window

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question