Enter the following formula in row 1 somewhere, then fill down through row 450:
=INT((ROW()+2)/3)&"_"&SUBSTITUTE(MOD(ROW(),3),"0","3")
Matt
=INT((ROW()+2)/3)&"_"&SUBSTITUTE(MOD(ROW(),3),"0","3")
Matt
=IF(--RIGHT(A1,1)=3,--LEFT(A1,1)+1,--LEFT(A1,1))&"_"&IF(--RIGHT(A1,1)<3,--RIGHT(A1,1)+1,1)
=IF(--RIGHT(A1,1)=3,--LEFT(A1,FIND("_",A1)-1)+1,--LEFT(A1,FIND("_",A1)-1))&"_"&IF(--RIGHT(A1,1)<3,--RIGHT(A1,1)+1,1)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!