Thread: Need help
View Single Post
 
Old 10-30-2022, 07:10 AM
karkey karkey is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default

Need to list files extension in like (*.eps, *.tif, *.jpeg) in provided path (any)

and add header above the list files as "Find" in Cell "A1" and "Change" in Cell "B1"

after that insert formula in Change Cell "A2", "A3", ... etc.

this formula to be insert: =INDEX({"IFig";"SFig";"Fig";"CFig"},MATCH(MID(LEFT (B3,FIND(".",$B3)-1),10,1),{"a";"s";"f";"c"},0)) & VALUE(MID(LEFT(B3,FIND(".",$B3)-1),11,2)) & MID(LEFT(B3,FIND(".",$B3)-1),13,99)
Reply With Quote