need formula help

Copper Contributor

I dont where is the error need help

=FILES(Sheet!$'B$1!&'\*"")

 

1 Reply

@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.