i want to remove all the spaces in the attached notepad.txt file and replace with a " | ".
when i do a find and replace and press the Space bar, then put the | in the replace it does not do anything. this is in notepad++
generally i am doing this when i take data from excel and need to put it into a .txt file in notepad. i always get spaces where the cells separate the data in excel. maybe there is a way to format the excel spreadsheet when i save it so the spaces are not there in the .txt file? expert-exchange-example.txt