The FIND Function The CELL Function returns workbookxlsxsheet , but we only want the sheet name, so we need to extract it from the result First though, we need to use the FIND Function to identify the location of the sheet name from the result =find("",E5) Returns The location of the "" character 18 in example above The MID FunctionIn Excel there isn't any one function to get the sheet name directly But you can get a sheet name using VBA, or you can use the CELL, FIND, and MID functions 1 = MID(CELL("filename"),FIND("",CELL("filename")) 1,31)The Excel CELL function returns information about a cell in a worksheet The type of information to be returned is specified as info_type CELL can get things like address and filename, as well as detailed info about the formatting used in the cell See below for a full list of information available
How To Reference Tab Name In Cell In Excel
