{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TEXTJOIN, TEXT and VLOOKUP","VBA 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":"TEXTJOIN, TEXT and VLOOKUP","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of TEXTJOIN, TEXT & VLOOKUP Functions"]
[]
[null,"Alphabets","Number",null,"Alphabet","Number"]
[null,"AA",{"$f":"_xlfn.TEXTJOIN(\"\", 1, TEXT(VLOOKUP((IF(1, MID(B5, ROW(INDIRECT(\"1:\" & LEN(B5))), 1))), $E$5:$F$30, 2, 0), \"00\"))","v":"0101"},null,"A",1]
[null,"GF",{"$f":"_xlfn.TEXTJOIN(\"\", 1, TEXT(VLOOKUP((IF(1, MID(B6, ROW(INDIRECT(\"1:\" & LEN(B6))), 1))), $E$5:$F$30, 2, 0), \"00\"))","v":"0706"},null,"B",2]
[null,"WA",{"$f":"_xlfn.TEXTJOIN(\"\", 1, TEXT(VLOOKUP((IF(1, MID(B7, ROW(INDIRECT(\"1:\" & LEN(B7))), 1))), $E$5:$F$30, 2, 0), \"00\"))","v":"2301"},null,"C",3]
[null,null,null,null,"D",4]
[null,null,null,null,"E",5]
[null,null,null,null,"F",6]
[null,null,null,null,"G",7]
[null,null,null,null,"H",8]
[null,null,null,null,"I",9]
[null,null,null,null,"J",10]
[null,null,null,null,"K",11]
[null,null,null,null,"L",12]
[null,null,null,null,"M",13]
[null,null,null,null,"N",14]
[null,null,null,null,"O",15]
[null,null,null,null,"P",16]
[null,null,null,null,"Q",17]
[null,null,null,null,"R",18]
[null,null,null,null,"S",19]
[null,null,null,null,"T",20]
[null,null,null,null,"U",21]
[null,null,null,null,"V",22]
[null,null,null,null,"W",23]
[null,null,null,null,"X",24]
[null,null,null,null,"Y",25]
[null,null,null,null,"Z",26]

{"sheet":"VBA UDF","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA User-Defined Function"]
[]
[null,"Alphabets","Number"]
[null,"AA",{"$f":"AlphabetToNumber(UPPER(B5))","v":"0101"}]
[null,"GF",{"$f":"AlphabetToNumber(UPPER(B6))","v":"0706"}]
[null,"WA",{"$f":"AlphabetToNumber(UPPER(B7))","v":"2301"}]