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 4010H4011H4012H4013HI 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:4010H4010H4010H4010H My plans was to concatenate the H, but how would I do that but keep editablility of the numbers? Is there a way to say current value+H?
Fill a column with consecutive numbers concatenated with a letter
google spreadsheets