#1
|
|||
|
|||
Need help
Can a header and add a formula in excel file using vba Header (e.g, Find, Change) add formula as in the output file. |
#2
|
|||
|
|||
Kindly help on this please
Kindly help on this please
|
#3
|
||||
|
||||
Please add some more explanation. your thread is as clear as your thread title, very obscure
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
Kindly help me on this.
|
|