<colgroup><col></colgroup><tbody>
There are files (pdf or msg) at folder "C:\Users":
AAA-1 (pdf)
AAA-2 (pdf)
AAA-3 (msg)
BBB-1 (pdf)
BBB-2 (pdf)
How to set the formula in excel to hyperlink to folder "C:\Users" showing files with word "AAA" only?
</tbody>
i.e. files AAA-1, AAA-2...