Google-sheets – Fill a column with consecutive numbers concatenated with a letter

concatenategoogle sheets

I want to concatenate a string after a numerical value in some columns automatically so that way they are still treated as numeric values.

For example:

A 
4010H
4011H
4012H
4013H

I want to be able to set one number and drag select it and fill in the rest of the column like you normal would with numbers. Ex:Type 4010 and then drag select the others and it fills the numbers 4011-4013.

However I need to keep the "H". The "H" breaks the numeric programming of the cells and it just duplicates the first cell.

Like this:

4010H
4010H
4010H
4010H

My plan was to concatenate the H, but how would I do that but keep editability of the numbers?

Is there a way to say current value+"H"?

Best Answer

After entering 4010H in the first row (cell A1), put the formula 

=split(A1, "H") + 1 & "H"

in cell A2, and drag that formula down.

It splits off "H", then adds 1, then puts "H" back again.

Related Topic