{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Set","Combine","Merge","Custom","Practice Sheet"],"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":"Data Set","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample Data Set"]
[]
[null,"Strings"]
[null,"Albus Severus Potter"]
[null,"Taiwan Semiconductor Manufacturing Co."]
[null,"Do or Die"]
[null,"William Somerset Maugham"]
[null,"Norton Corporation Limited"]
[null,"Intel Corporation"]
[null,"National Aeronautics and Space Administration"]

{"sheet":"Combine","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of Various Functions"]
[]
[null,"Strings","Abbreviation"]
[null,"Albus Severus Potter",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B5,\nROW(INDIRECT(\"1:\"&LEN(B5))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"ASP"}]
[null,"Taiwan Semiconductor Manufacturing Co.",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B6,\nROW(INDIRECT(\"1:\"&LEN(B6))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"TSMC"}]
[null,"Do or Die",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B7,\nROW(INDIRECT(\"1:\"&LEN(B7))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"DD"}]
[null,"William Somerset Maugham",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B8,\nROW(INDIRECT(\"1:\"&LEN(B8))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"WSM"}]
[null,"Norton Corporation Limited",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B9,\nROW(INDIRECT(\"1:\"&LEN(B9))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"NCL"}]
[null,"Intel Corporation",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B10,\nROW(INDIRECT(\"1:\"&LEN(B10))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"IC"}]
[null,"National Aeronautics and Space Administration",{"$f":"_xlfn.TEXTJOIN(\"\",1,IF(ISNUMBER(MATCH(CODE(MID(B11,\nROW(INDIRECT(\"1:\"&LEN(B11))),1)),\nROW(INDIRECT(\"63:90\")),0)),\nMID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"NASA"}]

{"sheet":"Merge","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Merging of Multiple Functions"]
[]
[null,"Strings","Abbreviation"]
[null,"Albus Severus Potter",{"$f":"UPPER(TRIM(LEFT(B5,1)&MID(B5,FIND(\" \",B5&\" \")+1,1)&\nMID(B5,FIND(\"*\",SUBSTITUTE(B5&\" \",\" \",\"*\",2))+1,1)))","v":"ASP"}]
[null,"Taiwan Semiconductor Manufacturing Co.",{"$f":"UPPER(TRIM(LEFT(B6,1)&MID(B6,FIND(\" \",B6&\" \")+1,1)&\nMID(B6,FIND(\"*\",SUBSTITUTE(B6&\" \",\" \",\"*\",2))+1,1)))","v":"TSM"}]
[null,"Do or Die","DOD"]
[null,"William Somerset Maugham","WSM"]
[null,"Norton Corporation Limited","NCL"]
[null,"Intel Corporation","IC"]
[null,"National Aeronautics and Space Administration","NAA"]

{"sheet":"Custom","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Custom Functions from VBA Code"]
[]
[null,"Strings","Abbreviation"]
[null,"Albus Severus Potter",{"$f":"AbbreviateString(B5)","v":"ASP"}]
[null,"Taiwan Semiconductor Manufacturing Co.",{"$f":"AbbreviateString(B6)","v":"TSMC"}]
[null,"Do or Die",{"$f":"AbbreviateString(B7)","v":"DOD"}]
[null,"William Somerset Maugham",{"$f":"AbbreviateString(B8)","v":"WSM"}]
[null,"Norton Corporation Limited",{"$f":"AbbreviateString(B9)","v":"NCL"}]
[null,"Intel Corporation",{"$f":"AbbreviateString(B10)","v":"IC"}]
[null,"National Aeronautics and Space Administration",{"$f":"AbbreviateString(B11)","v":"NAASA"}]

{"sheet":"Practice Sheet","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,">>> Practice Yourself <<<"]
[]
[null,"Strings"]
[null,"Albus Severus Potter"]
[null,"Taiwan Semiconductor Manufacturing Co."]
[null,"Do or Die"]
[null,"William Somerset Maugham"]
[null,"Norton Corporation Limited"]
[null,"Intel Corporation"]
[null,"National Aeronautics and Space Administration"]