View Single Post
  #1   Report Post  
sumesh56 sumesh56 is offline
Senior Member
 
Posts: 118
Default to give numbers to rows as per your wish

i have some 2000 plus records in a worksheet. i want to give the adjoining records numbers as 1A, 1B(for rows 1,2) 2A,3B(for rows 3,4) 3A, 3B (for rows 5,6) ----in this order. is it possible?
the first of each is a song title and second is the lyricist/musicdirector/singer
it should look like this

1A i want to sing
1B titanic/frac/jessy
2A heartful
2B george/perse/ki9n