Pulling down a cell to create a numeric sequence of entries in a column with a letter at the end

Question

I've been tasked to create a spreadsheet for asset tagging at our Facility. I've been given premade asset tags that have this layout... 890000A, 890001A, 890002A etc. I know that drop and drag works with letters then numbers, but what do I need to do the create a list of numbers that end in a letter?

Answer 1

To create a numeric sequence in Excel that ends with a letter, you can use a combination of the fill handle and a formula. Here’s how you can do it:

1. Start with the first entry: In the first cell, enter your starting value, for example, 890000A.
2. Create a formula for the next entry: In the second cell, enter the formula to increment the number while keeping the letter at the end. You can use the following formula: =TEXT(LEFT(A1, LEN(A1)-1) + 1, "000000") & "A" This formula takes the numeric part of the previous cell, increments it by 1, and then appends the letter "A" at the end.
3. Drag the fill handle: Click on the bottom-right corner of the cell with the formula (the fill handle) and drag it down to fill the cells below with the incremented values.

This will generate a list like 890000A, 890001A, 890002A, and so on.

Make sure to adjust the formula if you want to change the letter at the end or if you want to start from a different number.

---

References:

• Columns and rows are labeled numerically in Excel

Answer 2

Hi,

Enter this formula

=SEQUENCE(10,1,89000)&"A"

Hope this helps.