Forum Discussion

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Feb 13, 2024

    mestilda0821 

    It seems like you are trying to use a function named FILES with incorrect syntax. If you are trying to list files in a directory in Excel, you might need to use a different approach because Excel doesn't have a built-in function named FILES for this purpose.

     

    However, if you are trying to concatenate the contents of cell B1 on the "Sheet" sheet with a wildcard character (*), you can use the CONCATENATE function or the "&" operator to achieve that. Here is the corrected formula:

    =Sheet1!$B$1 & "*"

    This formula will concatenate the content of cell B1 in the sheet named "Sheet1" with an asterisk (*) character. Make sure to adjust the sheet name accordingly if it's different in your actual workbook. If you meant something different, please provide more context. Contex to your question in this forum. AI was partially deployed to support the text.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark as best response and Like it!

    This will help all forum participants.

Resources