Hi, guys! I don't think that absence of space before Chr(13) is the reason for the error (what kind of error?). Presence of space is just a condition. If it is not positive, the code goes on to the next paragraph. I've checked it on different paragraphs. And again, it's curious and challenging, but the code from post 27 works smoothly on the Test_Test file sent by RobiNew previously!

Note that the code removes only 1 space at one run. To remove all spaces, Do...Loop is needed.