Share via

Excel Alphanumeric ID generator

Anonymous
2022-02-08T03:35:04+00:00

How do I create an excel tracker to generate codes starting with CR, so first row CR001, then the next line when someone wants to add description it generates CR002 automatically?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-02-08T09:32:03+00:00

    Hi there

    You may try the following

    1. With the formula =IF(B2="","","CR"&TEXT(ROW()-ROW($A$1),"000"))

    Image

    OR

    1. Simply inserting the serial numbering in the "Code" column and Custom Format the range

    Image

    Image

    I hope this helps you and gives a solution to your problem

    Do let me know if you need more help

    Regards

    Jeovany

    4 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2022-02-08T04:57:42+00:00

    Image

    If a visual output is sufficient:

    Write just the numbers 1,2,3, etc into column A and format the column with this format:

    "CR"000

    Otherwise:

    You have to parse the number from the previous cell, increase by 1 and format the output.

    A2: ="CR" & RIGHT("000" & RIGHT(A1,3)+1,3)

    Andreas.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest