Thank you so much for the clue!!! I finally got it!!!
It has definitely got to do with text format that Excel uses. After I opened the file with "TextEdit" & changed the format and style, I could finally use
sed or
grep to it
I had to convert it into "Rich Text Format" then I could
sed it into output.txt format. It gave me lines with "\" at the end but that's ok I could use
perl, find and replace.
I was so lucky as the file is not more than 10mb though. If it's like 200gb like before, this project is simply dead.
I m not sure if there's a command to change the text format without using "TextEdit". If there is, it would be simply AWESOME
Anyways, thank you all for your help and sorry I caused too much trouble. :S
Moral of the Story : Don't play with Excel
I could use
perl on the txt that just come out of Excel though. If only there's a way to remove lines containing digits using
perl
Once again, thank you all