I have a text file (*.txt) that I want to modify before using in excel. I want to replace the return carriage with (Char 13) as long as the return carriage is not proceeded by a certain code. The code is fixed but there is a lot of different variations to the code, so if someone could help me with only one variation, I hope I will be able to do the rest.
So the macro should:
1. open the txt file via Word
2. replace the carriage breaks that are not proceeded by a code with (Char 13)
3. save the txt file
Example attached.
Thanks.
Abousetta
Bookmarks