🔹 CONCATENATE A1 : =CONCATENATE(ADDRESS (ROW(),2,4),":",ADDRESS (ROW(),5,4)) Result : B1:E1 eitaa.com/Electronic_Groups/224