Originally Posted by sumesh56

thanks for the suggestion.your formula is related to exact row numbers. but this has a problem. the row one contains the header.the data starts from row2. so if i type the formula on row2 i get the wrong numbering.i get 1B instead of 1A. if the data starts from row5 (for example) and i want to give numbers from row 6 as 1A and to row 7 as 1B and so on.in brief the formula should be free from exact row numbers. is it possible?