What Excel formula returns the sheet name?

Not very good with excel, but I found these here

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

and A1 can be any non-error cell in the sheet.
For the full path and name of the sheet, use

=CELL("filename",A1)

Related Posts:

  1. Excel to Google Sheets – Error: Formula parse error
  2. Is there Infinity in Spreadsheets?
  3. Declaring variables in Excel Cells
  4. How to loop in excel without VBA or macros?
  5. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  6. Using SUBSTITUTE with wildcard characters
  7. Shortcut to Apply a Formula to an Entire Column in Excel
  8. MS Excel Scatterplot converts Months to Numbers
  9. Substring in excel
  10. Swap x and y axis without manually swapping values
  11. Excel: Calculate the frequency of a particular month in a column of date cells
  12. Object Required Error in excel VBA
  13. Insert picture into Excel cell
  14. What is a correct MIME type for .docx, .pptx, etc.?
  15. What are .NumberFormat Options In Excel VBA?
  16. Better way to find last used row
  17. VBA, if a string contains a certain letter
  18. Excel VBA Macro: User Defined Type Not Defined
  19. Add a “sort” to a =QUERY statement in Google Spreadsheets
  20. What is correct content-type for excel files?
  21. How do I get countifs to select all non-blank cells in Excel?
  22. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  23. Excel – SUMIFS for multiple columns
  24. Workaround for “Formula omits adjacent cells”
  25. Select method of Range class failed via VBA
  26. Does VBA contain a comment block syntax?
  27. Why does “Paste Method of Worksheet class failed” occasionally occur?
  28. check if a file is open in Python
  29. How to return a result from a VBA function
  30. Select all the cells below current cell in excel
  31. How to clear memory to prevent “out of memory error” in excel vba?
  32. Use VBA to Clear Immediate Window?
  33. VBA: Else without If Error
  34. Recommended IDE for VBA
  35. ByRef argument type mismatch in Excel VBA
  36. How do I open space-delimited file in Microsoft Excel?
  37. VBA: Convert Text to Number
  38. VBA Error: “Compile error: Expected End Sub”
  39. Change default ‘delimiters’ in excel
  40. Error: “Could Not Find Installable ISAM”
  41. Converting time stamps in excel to dates
  42. Adding a newline character within a cell (CSV)
  43. VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
  44. Loop without Do error
  45. Row count where data exists
  46. (Excel) Conditional Formatting based on Adjacent Cell Value
  47. Test or check if sheet exists
  48. How to detect if user select cancel InputBox VBA Excel
  49. macro run-time error ‘9’: subscript out of range
  50. How to label scatterplot points by name?
  51. Why does my VBA code throw an “Invalid outside procedure” error?
  52. Excel Solver Password: what is it and where can it be acquired/bought?
  53. Choosing paper size (NOT DEFAULT sizes) in excel vba
  54. Compile error: Next without For || VBA
  55. Is there a way to crack the password on an Excel VBA Project?

Leave a Comment