Row naming

Copper Contributor

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. 

1 Reply

@nviet460 

That could be

="HRT_" & TEXT(INT(ROW()/100),"00") & "_" & TEXT(MOD(ROW(), 100), "00")

 or like