Row naming

%3CLINGO-SUB%20id%3D%22lingo-sub-2661350%22%20slang%3D%22en-US%22%3ERow%20naming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661350%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20rows%20based%20on%20two%20different%20variable%20that%20are%20measured%20in%20seconds.%20Although%20I%20don't%20want%20to%20have%20to%20manual%20change%20the%20name%20of%20each%20row%20because%20I%20have%20~1000.%20Is%20there%20a%20function%20that%20would%20allow%20me%20to%20enter%20a%20name%20like%20HRT_00_00%20then%20HRT_00_01%20then%20HRT_00_02%20and%20so%20on%3F%20So%20the%20first%20three%20letter%20would%20be%20identical%2C%20the%20only%20thing%20that%20would%20change%20would%20be%20the%20numbers%20as%20the%20columns%20move%20from%20A%20to%20Z.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2661350%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2662532%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20naming%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2662532%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131517%22%20target%3D%22_blank%22%3E%40nviet460%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3D%22HRT_%22%20%26amp%3B%20TEXT(INT(ROW()%2F100)%2C%2200%22)%20%26amp%3B%20%22_%22%20%26amp%3B%20TEXT(MOD(ROW()%2C%20100)%2C%20%2200%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3Bor%20like%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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