[TABLE="width: 524"]
<colgroup><col></colgroup><tbody>[TR]
[TD]There is folder "Doc" at C:\ that has 5 files say:[/TD]
[/TR]
[TR]
[TD]File 1[/TD]
[/TR]
[TR]
[TD]File 2[/TD]
[/TR]
[TR]
[TD]File 3[/TD]
[/TR]
[TR]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Other 2[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]where File 1,2 and Other 2 is pdf and remaining is msg.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The formula below can hyperlink to folder "Doc":[/TD]
[/TR]
[TR]
[TD]=HYPERLINK("C:\Doc","File")[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]How to modify the formula to show folder with file having specified word "File" only?[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 524"]
<tbody>[TR]
[TD](Same result as search word "File" at folder "Doc")[/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col></colgroup><tbody>[TR]
[TD]There is folder "Doc" at C:\ that has 5 files say:[/TD]
[/TR]
[TR]
[TD]File 1[/TD]
[/TR]
[TR]
[TD]File 2[/TD]
[/TR]
[TR]
[TD]File 3[/TD]
[/TR]
[TR]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Other 2[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]where File 1,2 and Other 2 is pdf and remaining is msg.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The formula below can hyperlink to folder "Doc":[/TD]
[/TR]
[TR]
[TD]=HYPERLINK("C:\Doc","File")[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]How to modify the formula to show folder with file having specified word "File" only?[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 524"]
<tbody>[TR]
[TD](Same result as search word "File" at folder "Doc")[/TD]
[/TR]
</tbody>[/TABLE]