Forum Discussion
Excel Row Pattern
Is there a formula or way I can make multiple decimals continuously adding like so .001.001 .002.002 .003.003 but also have text in front of the 1st decimal
HelloTannerCreamer​, Use this formula in A1 and drag down: ="Item "&MID(TEXT(ROW(A1)/1000,"0.000"),2,5)&"."&MID(TEXT(ROW(A1)/1000,"0.000"),2,5) This produces Item .001.001, Item .002.002, Item .003.003 with text in front.