I might have found a way, until now i was "opening" up the txt file from excel (file, open, etc..). This time I copied the whole txt, pasted it into excel and filtered out the Y and then I copied back again to np++ and the spacing was there! Woohoo.
Thanks guys.