{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["CELL_Formula","VBA","Example_for_Sheet_Name"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"CELL_Formula","index":0,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[]
[null,"Sheet Name with Cell function"]
[]
[null,"Function:",{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-SEARCH(\"]\",CELL(\"filename\",A1)))","v":"CELL_Formula"}]

{"sheet":"VBA","index":1,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[]
[null,"Sheet Name with VBA Macro"]
[]
[null,"Function:",{"$f":"PROFEXSheetName(A1)","v":"VBA"}]

{"sheet":"Example_for_Sheet_Name","index":2,"n_rows":10,"n_cols":4,"rows_kept":10}
[]
[]
[null,"Example"]
[]
[null,"CELL function",null,{"$f":"SUBSTITUTE(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-SEARCH(\"]\",CELL(\"filename\",A1))),\"_\",\" \")","v":"Example for Sheet Name"}]
[null,"VBA macro",null,{"$f":"SUBSTITUTE(PROFEXSheetName(A3),\"_\",\" \")","v":"Example for Sheet Name"}]
[]
[null,"Explanation: "]
[null,null,"This example returns the sheet name in two methods (CELL-function and VBA)"]
[null,null,"Then, it removes all underscores and fills in blanks instead"]