I have a folder with txt files and in a sheet I have comments from A1 going down to A...
I would like to compare the txt filenames with the values in the sheet and rename the files per example below.
In the folder, the files are named in various ways, as an example:
Mark; repopulate - export.txt
[came to early] Nick .txt
John - late for work.txt
etc
In a sheet, starting at A1 and going down (A2,A3 A4 etc) I have a list of comments. The important thing about the comments is that
they have a number in front before the comment begins and the number is separated by a space before the actual comment. For example,
1 Mark, repopulate
20 John Late
100 Nick to early
etc
I would like to compare the txt filenames with the comments in the sheet from A1 going down to A..., and when there is a match of most words, add the number in front of the filename of the txt.
So with the above example,
Mark; repopulate - export.txt to be renamed to 1 Mark; repopulate - export.txt
[came to early] Nick.txt to be renamed to 100 [came to early] Nick.txt
John - late for work.txt to be renamed 20 John - late for work.txt
I hope the above makes sense.
Any help is greatly appreciated. Thank you.
Bookmarks