{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["TEXTAFTER","MID","RIGHT","INDEX","UDF","VBA","Reference","CELL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TEXTAFTER","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using TEXTAFTER Function"]
[]
[null,"Formula","Sheet Name"]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TEXTAFTER(CELL(\"filename\",A1),\"]\")"},{"$f":"_xlfn.TEXTAFTER(CELL(\"filename\",A1),\"]\")","v":"TEXTAFTER"}]

{"sheet":"MID","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using MID & FIND Functions"]
[]
[null,"Formula","Sheet Name"]
[null,"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)",{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"MID"}]

{"sheet":"RIGHT","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using RIGHT,LEN and FIND Functions"]
[]
[null,"Formula","Sheet Name"]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=RIGHT(CELL(\"filename\"), LEN(CELL(\"filename\")) - FIND(\"]\", CELL(\"filename\")))"},{"$f":"RIGHT(CELL(\"filename\"), LEN(CELL(\"filename\")) - FIND(\"]\", CELL(\"filename\")))","v":"CELL"}]

{"sheet":"INDEX","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using INDEX, MID and FIND Functions"]
[]
[null,"Formula","Sheet Name"]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=INDEX(MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255),1)"},{"$f":"INDEX(MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255),1)","v":"INDEX"}]

{"sheet":"UDF","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using User Defined Function"]
[]
[null,"User Defined Function","Sheet Name"]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=SheetName()"},{"$f":"SheetName()","v":"UDF"}]

{"sheet":"VBA","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Code"]
[]
[null,"Method","Sheet Name"]
[null,"Visual Basic Code","VBA"]

{"sheet":"Reference","index":6,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Referencing Sheet Name"]
[]
[null,"Method","Sheet Name"]
[null,"Visual Basic Code",{"$f":"VBA!C5","v":"VBA"}]
[null,"User Defined Function",{"$f":"UDF!C5","v":"UDF"}]

{"sheet":"CELL","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using CELL Function"]
[]
[null,"Formula","Sheet Name"]
[null,{"$f":"_xlfn.FORMULATEXT(C5)","v":"=CELL(\"filename\")"},{"$f":"CELL(\"filename\")","v":"C:\\Users\\HP\\Downloads\\[Excel_Sheet_Name (1).xlsm]CELL"}]