Extract List of Multipal Sheet Name from Microsoft Excel File (Without Using VBA Code)

In this video, we take a look at how to extract list of sheet names in an Excel workbook with and without VBA.

Formula used in above video:

=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")