-Dman100-
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.