How do I autofill combination of letters and numbers so that the numbers increment by 1?

**tborek** · 08-23-2021, 11:20 AM

I'm trying to add SKU numbers to my inventory on a spreadsheet and want to put sku numbers as W01, W02, W03, etc and L01, L02, L03, etc. How do I autofill combination of letters and numbers so that the numbers increment by 1? When I use the fill option it just keeps the same text as the previous text box.

**alansidman** · 08-23-2021, 11:45 AM

If I type W01 in A1 and W02 in A2 and then highlight both cells and grab the little plus in the lower right hand corner and drag down, it autofills to the the cell I stop dragging to.

**tborek** · 08-23-2021, 01:04 PM

That doesn't work for me. When I highlight the 2 cells and drag down it just duplicates the last cell over and over.

**alansidman** · 08-23-2021, 02:03 PM

Did you try with three cells. That works for me.

How do I autofill combination of letters and numbers so that the numbers increment by 1?

LinkBack

Thread Tools

Rate This Thread

Display

How do I autofill combination of letters and numbers so that the numbers increment by 1?

Re: How do I autofill combination of letters and numbers so that the numbers increment by

Re: How do I autofill combination of letters and numbers so that the numbers increment by

Re: How do I autofill combination of letters and numbers so that the numbers increment by

Thread Information

Users Browsing this Thread

Similar Threads

Excel combination of letters and numbers

Macro needed to increment numbers but keeping the same letters.

combination of numbers or letters

[SOLVED] Quick problem - string mix of letters & numbers - increment by one

How to autofill numbers with letters

Sum numbers with certain combination of letters

insert combination of random letters and numbers - an example

Bookmarks

Bookmarks

Posting Permissions