Generate new name of file based on Original file name

Hello,

I have a list in excel of the files in folder. The filenames are of the form "1FT_DINRM_Bru_pt5GAL_TCL.wav". I want to rename the files with only numbers. The numbers are based as follows:

2021-08-15_23-13-11.png

For the filename given above, "1FT_DINRM_Bru_pt5GAL_TCL.wav", the output name to be generated will be "10003010500.wav". Another example for the file with an original name of "24FT10IN_Ane_Zm_4GAL_TCL_lclp.wav", the output file name will be "24100060240001.wav".

Is there a way to accomplish this? If so, can you tell me how to go about doing this? I was thinking along the lines of XLOOKUP?

For this use case, I would like to put the file names in one column, and the adjacent column will have the corresponding converted name.

Any help will be greatly appreciated.

THANK YOU! Your code works perfectly!

Just wanted to tell you once again...that your code have been such a life saver for me. I sincerely appreciate you taking the time out to help me out the way you did. I really sincerely appreciate it! Cheers!