hi I wnt to do numbering in excel sheet . There should be a prefix like: ANA etc. for each row.
A anshu Apr 16, 2007 #1 hi I wnt to do numbering in excel sheet . There should be a prefix like: ANA etc. for each row.
M Max Apr 16, 2007 #2 One ways Put in any starting cell as desired, say in C3: ="ANA"&TEXT(ROW(A1),"000") Copy C3 down as far as required to return the series: ANA001 ANA002 ANA003 etc Modify to suit ..
One ways Put in any starting cell as desired, say in C3: ="ANA"&TEXT(ROW(A1),"000") Copy C3 down as far as required to return the series: ANA001 ANA002 ANA003 etc Modify to suit ..
