How is your song data structured? Are whole lyrics contained in a single cell, or have you broken out each word into a separate row (with song title in a corresponding column)?
It would be good if you could upload a workbook or some data.
Okey, here is the sample workbook. Someone asked this question to me and send this workbook. So, all i have is this