Hi can someone help me with a vba macro please.
I have a folder with text files I need to go through each text file and delete from the first row the comma and the words after the comma, only the first row. For example on row 1 it says
Amazon 13th July 1471,sold 4
so the macro would delete ",sold 4"