Aug 18 2021 08:53 AM
I'm trying to create rows based on two different variable that are measured in seconds. Although I don't want to have to manual change the name of each row because I have ~1000. Is there a function that would allow me to enter a name like HRT_00_00 then HRT_00_01 then HRT_00_02 and so on? So the first three letter would be identical, the only thing that would change would be the numbers as the columns move from A to Z.
Aug 18 2021 01:25 PM
That could be
="HRT_" & TEXT(INT(ROW()/100),"00") & "_" & TEXT(MOD(ROW(), 100), "00")
or like