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