{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["COLUMN Function","CODE Function","MATCH Function","TEXTJOIN & VLOOKUP Functions","SUBSTITUTE Function","VBA","COLUMN Function (2)","UDF"],"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":"COLUMN Function","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of COLUMN Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabet","Number",null,null,null,null,null,null,"Alphabet","Number"]
[null,"A",{"$f":"COLUMN(INDIRECT(B5&1))","v":1},null,null,null,null,null,null,"A"]
[null,"B",{"$f":"COLUMN(INDIRECT(B6&1))","v":2},null,null,null,null,null,null,"B"]
[null,"C",{"$f":"COLUMN(INDIRECT(B7&1))","v":3},null,null,null,null,null,null,"C"]
[null,"d",{"$f":"COLUMN(INDIRECT(B8&1))","v":4},null,null,null,null,null,null,"d"]
[null,"E",{"$f":"COLUMN(INDIRECT(B9&1))","v":5},null,null,null,null,null,null,"E"]
[]
[]
[]
[null,null,{"$f":"match","v":{"$error":"#NAME?"}}]

{"sheet":"CODE Function","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of CODE Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabet","Number",null,null,null,null,null,null,"Alphabet","Number"]
[null,"A",{"$f":"CODE(UPPER(B5))-64","v":1},null,null,null,null,null,null,"A"]
[null,"B",{"$f":"CODE(UPPER(B6))-64","v":2},null,null,null,null,null,null,"B"]
[null,"C",3,null,null,null,null,null,null,"C"]
[null,"d",4,null,null,null,null,null,null,"d"]
[null,"E",5,null,null,null,null,null,null,"E"]

{"sheet":"MATCH Function","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of MATCH Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabet","Number",null,null,null,null,null,"Alphabet","Number"]
[null,"A",{"$f":"MATCH(B5&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":1},null,null,null,null,null,"A"]
[null,"B",{"$f":"MATCH(B6&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":2},null,null,null,null,null,"B"]
[null,"C",{"$f":"MATCH(B7&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":3},null,null,null,null,null,"C"]
[null,"d",{"$f":"MATCH(B8&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":4},null,null,null,null,null,"d"]
[null,"E",{"$f":"MATCH(B9&\"1\",ADDRESS(1,COLUMN($1:$1),4),0)","v":5},null,null,null,null,null,"E"]

{"sheet":"TEXTJOIN & VLOOKUP Functions","index":3,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Use of TEXTJOIN & VLOOKUP Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabets","Number",null,"Alphabet","Number",null,"Alphabets","Number",null,"Alphabet","Number"]
[null,"ADE",{"$f":"_xlfn.TEXTJOIN(\"\",1,VLOOKUP(T(IF(1,MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1))),E5:F30,2,0))","v":"145"},null,"A",1,null,"ADE",null,null,"A",1]
[null,"BX",{"$f":"_xlfn.TEXTJOIN(\"\",1,VLOOKUP(T(IF(1,MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1))),E6:F31,2,0))","v":"224"},null,"B",2,null,"BX",null,null,"B",2]
[null,"CMZ",{"$f":"_xlfn.TEXTJOIN(\"\",1,VLOOKUP(T(IF(1,MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1))),E7:F32,2,0))","v":"31326"},null,"C",3,null,"CMZ",null,null,"C",3]
[null,"Dky",{"$f":"_xlfn.TEXTJOIN(\"\",1,VLOOKUP(T(IF(1,MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1))),E8:F33,2,0))","v":"41125"},null,"D",4,null,"Dky",null,null,"D",4]
[null,"ERH",{"$f":"_xlfn.TEXTJOIN(\"\",1,VLOOKUP(T(IF(1,MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1))),E9:F34,2,0))","v":"5188"},null,"E",5,null,"ERH",null,null,"E",5]
[null,null,null,null,"F",6,null,null,null,null,"F",6]
[null,null,null,null,"G",7,null,null,null,null,"G",7]
[null,null,null,null,"H",8,null,null,null,null,"H",8]
[null,null,null,null,"I",9,null,null,null,null,"I",9]
[null,null,null,null,"J",10,null,null,null,null,"J",10]
[null,null,null,null,"K",11,null,null,null,null,"K",11]
[null,null,null,null,"L",12,null,null,null,null,"L",12]
[null,null,null,null,"M",13,null,null,null,null,"M",13]
[null,null,null,null,"N",14,null,null,null,null,"N",14]
[null,null,null,null,"O",15,null,null,null,null,"O",15]
[null,null,null,null,"P",16,null,null,null,null,"P",16]
[null,null,null,null,"Q",17,null,null,null,null,"Q",17]
[null,null,null,null,"R",18,null,null,null,null,"R",18]
[null,null,null,null,"S",19,null,null,null,null,"S",19]
[null,null,null,null,"T",20,null,null,null,null,"T",20]
[null,null,null,null,"U",21,null,null,null,null,"U",21]
[null,null,null,null,"V",22,null,null,null,null,"V",22]
[null,null,null,null,"W",23,null,null,null,null,"W",23]
[null,null,null,null,"X",24,null,null,null,null,"X",24]
[null,null,null,null,"Y",25,null,null,null,null,"Y",25]
[null,null,null,null,"Z",26,null,null,null,null,"Z",26]

{"sheet":"SUBSTITUTE Function","index":4,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,null,null,"Use of SUBSTITUTE Function"]
[]
[null,"Alphabets","Number",null,null,null,null,null,"Alphabets","Number"]
[null,"ABC",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5,\"A\",1),\"B\",2),\"C\",3),\"D\",4)","v":"123"},null,null,null,null,null,"ABC"]
[null,"BA",{"$f":"SUBSTITUTE(SUBSTITUTE(\nSUBSTITUTE(SUBSTITUTE(\nB6,\"A\",1),\"B\",2),\"C\",3),\"D\",4)","v":"21"},null,null,null,null,null,"BA"]
[null,"CA","31",null,null,null,null,null,"CA"]
[null,"DBC","423",null,null,null,null,null,"DBC"]
[null,"ADC","143",null,null,null,null,null,"ADC"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabets","Number",null,null,null,null,null,null,"Alphabets","Number"]
[null,"Abc",{"$f":"AlphabetToNumber(UPPER(B5))","v":"123"},null,null,null,null,null,null,"Abc"]
[null,"BA",{"$f":"AlphabetToNumber(UPPER(B6))","v":"21"},null,null,null,null,null,null,"BA"]
[null,"MN",{"$f":"AlphabetToNumber(UPPER(B7))","v":"1314"},null,null,null,null,null,null,"MN"]
[null,"dBc",{"$f":"AlphabetToNumber(UPPER(B8))","v":"423"},null,null,null,null,null,null,"dBc"]
[null,"XZ",{"$f":"AlphabetToNumber(UPPER(B9))","v":"2426"},null,null,null,null,null,null,"XZ"]

{"sheet":"COLUMN Function (2)","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of COLUMN Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabet","Number",null,null,null,null,null,null,null,"Alphabet","Number"]
[null,"A",{"$f":"COLUMN(INDIRECT(B5&1))","v":1},null,null,null,null,null,null,null,"A"]
[null,"BB",{"$f":"COLUMN(INDIRECT(B6&1))","v":54},null,null,null,null,null,null,null,"BB"]
[null,"CX",{"$f":"COLUMN(INDIRECT(B7&1))","v":102},null,null,null,null,null,null,null,"CX"]
[null,"MN",{"$f":"COLUMN(INDIRECT(B8&1))","v":352},null,null,null,null,null,null,null,"MN"]
[null,"XFD",{"$f":"COLUMN(INDIRECT(B9&1))","v":16384},null,null,null,null,null,null,null,"XFD"]

{"sheet":"UDF","index":7,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of User Defined Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Alphabet","Number",null,null,null,null,null,"Alphabet","Number"]
[null,"A",{"$f":"ColNumber(B5)","v":1},null,null,null,null,null,"A"]
[null,"BB",{"$f":"ColNumber(B6)","v":54},null,null,null,null,null,"BB"]
[null,"CX",{"$f":"ColNumber(B7)","v":102},null,null,null,null,null,"CX"]
[null,"MN",{"$f":"ColNumber(B8)","v":352},null,null,null,null,null,"MN"]
[null,"XFD",{"$f":"ColNumber(B9)","v":16384},null,null,null,null,null,"XFD"]