I want to concatenate a string after a numerical value in some columns automatically so that way they are still treated as numeric values.
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.
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"?