Hi, I have a bunch of text files I need to add the filename at the end of each paragraph to. There's a lot of paragraphs in each file. Ideally it would have a dash, space, then the filename (without extension) so it would look something like this: line with text - filename
Its data that i am going to port into excel, but i want the filename after each paragraph so when i have all the data in excel (I have a few hundred files) and sort them, i know what file it came from. Originally I should have created tables in word for the data, but there's so much data there now it would take me weeks (maybe longer) to convert everything into a table, adding the filenames manually. So I thought if I could add the filename at the end of each paragraph I could batch import it into excel, into one file, making it easier to track.
I am not sure what the best way to do this is. thanks.