Hope you understood How to get only sheet name of the worksheet in Excel 16 Find more articles on Excel TEXT functions here Please share your query below in the comment box We will assist you Popular Articles 50 Excel Shortcut to Increase Your Productivity Get faster at your task Watch Video – Get List of File Names from a Folder in Excel Using VBA Get a List of All the File Names from a Folder File listing in Excel sheet of any directory and nested sub directories, with many properties of the files is so easy with many menu driven options (MenuFile & SystemItem 24) This is just one of more than 300 utilities Creating worksheet tab names in a distinct and uneatable list is a tedious task Using Excel VBA is the answer to this problem Over the years I have worked with some large workbooks At times finding sheets can be difficult Also keeping track of all the sheets in the workbook via an index is often useful
1
