Im not too experienced with macros, but i know they use mostly VB. what i would try doing first would be to move the cursor to the beginning of each row and set the cursor location as the startindex of remove (remove(cursor, N) ) but idk if thats possible. If not, you could use sendkeys. I could write a VB program that does this to a txt file but im not sure how to do it in a macro.