View Single Post
 
Old 08-16-2013, 07:39 AM
Tuna425 Tuna425 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2013
Posts: 1
Tuna425 is on a distinguished road
Default 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
Reply With Quote