Solved

Auto increment alphanumeric field

Posted on 2015-02-10
2
130 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now