greetings everyone,
here's my situation, i'm trying to rename all the files, folders, subfolders, and also the files inside the subfolders in a path. The files/folders have "14" on their names.
my trainer told me that it can be done using regular expressions, but i'm having a hard time understanding how to use it.![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
example:
in C:\Test\
Luis14_OS.xls to Luis15_OS.xls
Bong14_OS.xls to Bong15_OS.txt
Gina14_OS.xls to Gina15_OS.docx
June14 (This is a folder)
inside june 14, (C:\Test\June14\)
Marcus14.iso to Marcus15.iso
ouch_14a.xlsm to ouch_15a.xlsm
Thanks in advance excel experts..![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
here's my situation, i'm trying to rename all the files, folders, subfolders, and also the files inside the subfolders in a path. The files/folders have "14" on their names.
my trainer told me that it can be done using regular expressions, but i'm having a hard time understanding how to use it.
example:
in C:\Test\
Luis14_OS.xls to Luis15_OS.xls
Bong14_OS.xls to Bong15_OS.txt
Gina14_OS.xls to Gina15_OS.docx
June14 (This is a folder)
inside june 14, (C:\Test\June14\)
Marcus14.iso to Marcus15.iso
ouch_14a.xlsm to ouch_15a.xlsm
Thanks in advance excel experts..