[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Auto increment alphanumeric field

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
-Dman100-
Asked:
-Dman100-
2 Solutions
 
deanomacCommented:
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
 
Shaun KlineLead Software EngineerCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now