convert list to columns
Here's my problem. I have a list of songs for a karaoke machine but there is no definition between the song and it's number and singer.
Here is an example
1-2-3 09471 GLORIA ESTEFAN G. ESTEFAN
10,000 PROMISES 09401 BACKSTREET BOYS SANDBERG
The list is 97 pages long. I would like to be able to separate it into columns like this.
1-2-3 xxxxxxxxxxxxxxxxxxx09471xxxxxxxxxxx GLORIA ESTEFAN G. ESTEFAN
10,000 PROMISES xxxxxxx09401 xxxxxxxxxx BACKSTREET BOYS SANDBERG
(sorry for the x's couldn't figure out how else to do it.)
Just so I can copy it into excel then sort by song or artist
Any suggestions
|