LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which numbers give desired result Studebaker Excel Discussion (Misc queries) 14 April 29th 08 09:22 PM
how do i give numbers to documents in Excel? excel nombers Excel Discussion (Misc queries) 1 October 6th 07 07:02 PM
How to give numbers to the font colors Igneshwara reddy[_2_] Excel Worksheet Functions 2 August 24th 07 01:34 AM
how can i get VBA to give rows numbers Bahnando Excel Programming 2 October 24th 06 09:19 AM
why does dividing numbers give me dates and not numbers? dylan Excel Discussion (Misc queries) 1 June 21st 06 11:40 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"