Skip to content

Create an Alphanumeric List in Excel

In this article, I will show you how to create an alphanumeric list in Excel.

There is a fast way and a slow way to do it. I will cover both!

What is an Alphanumeric List?

An alphanumeric list is simply a list of values containing both letters and numbers. For example, an alphanumeric list might look something like this.

  • AB-1
  • AB-2
  • AB-3
  • etc…

An alphanumeric list may be useful for product or user IDs within a spreadsheet or database. It has a few other uses as well, I’m sure.

But the real question is – how can you create an alphanumeric list in Excel?

The Slow Way

The slow way to create an alphanumeric list in Excel would be to type in the first value and then use the fill handle to complete the list.

For instance, here I have some employee information.

The goal is to create a unique alphanumeric user ID for each employee. I can do this by typing in the first user ID like so.

I can then use the fill handle to drag this value down to create a unique alphanumeric ID for each employee.

This method works, but if you deal with thousands of records instead of ten, then this method might not be the best solution.

The Fast Way

Here is a faster way to create an ordered alphanumeric list in Excel. I have the same employee data as before.

This time, I will select the cell where the first user ID will go and type in the following formula.

="ABC-"&SEQUENCE(10)

This formula takes the typed-in text and combines it with the SEQUENCE function. The SEQUENCE function generates an array of numbers from one to the specified number.

And the best part is that all of the user IDs are created in an instant. The key is knowing how many user IDs you need.

My one warning with this approach is that you need to be an Office 365 subscriber or have Excel 2021 or newer for this to work. If you are working in an older version of Excel, you will have to resort to the first method mentioned in this article.

That said, I hope you enjoyed this article and learned something new. Leave me a comment below if you have any questions or thoughts that you would like to share!

This Post Has One Comment

  1. I didn’t even know that the way I was doing it was the slow way! This is going to be so helpful to keep in my back pocket!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top