Alphabetically, 06 is before 07, therefore songs from Thuy Nga will be before those in Asia.

Download the mp4 file in post #1 to see it clearer. The whole purpose of the video is to make it clearer. "A picture says a thousand words". A video consists of thousands of pictures so "A video says a million words".

Let me tag along on how I create an Excel Song Catalog

1) Create a text file song catalog:
a) Run TKaraoke software
b) Click "Tools" then "Generate Song Catalog"
c) Type %number%;%song%;%singer%;%album%;%lyric% in "Enter Song Catalog Format" popup window
d) Default file name to be saved is "TKaraoke Song Catalog" make a note of the location of the file.

2) Use Notepad to open the file just created above.

3) Select "File", then "Save As" from Notepad, at the bottom select "Unicode" for encoding (This step would convert the text file to "Unicode" text file so that Vietnamese language will be displayed properly)

4) Run MS Excel, Click Open (To select the unicode file you have to change file type from "All Excel Files" to "All File") then navigate to the file you saved in step 3.

5) "Text Import Wizard" will popup. Click "Next".

6) On next screen, select Semicolon as the "Delimeters". Click "Next".

7) Click "Finish", this will create a spreadsheet for your song catalog. Using Excel you can sort each column alpha-numerically

Edited by user Sunday, September 23, 2012 3:28:43 PM(UTC)  | Reason: Not specified

admin cho mình hỏi chút mình tạo list lần 1 ok rồi đem đi in. đóng thành quyển

sau đó mình cập nhập thêm bài hát vào

thì mình tạo lại list thì thứ tự bài hát trước kia bị thay đổi . như thế list trước kia bỏ đi sẽ rất phí

có cách nào khắc phục được ko vậy

mong admin trả lời giùm


Thank

i was looking for how to do this thanks