{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Multiple Functions","Combining Functions","Text to Column","Flash Fill","VBA"],"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":"Dataset","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name and Age List of Students"]
[]
[null,"Name, Age"]
[null,"John, 18 yr"]
[null,"Frank, 16 yr"]
[null,"William, 21 yr"]
[null,"Adam, 23 yr"]
[null,"Rose, 17 yr"]
[null,"Anna, 15 yr"]
[null,"Robert, 19 yr"]
[null,"Henry, 22 yr"]
[null,"Elizabeth, 25 yr"]
[null,"Arthur, 20 yr"]

{"sheet":"Multiple Functions","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,4,1],[1,1,1,3],[1,6,1,8],[3,6,4,6]]}
[]
[null,"Applying LEN, MID, REPT, SUBSTITUTE and TRIM Functions",null,null,null,null,"Do It Yourself"]
[]
[null,"Name, Age","Name","Age",null,null,"Name, Age","Name","Age"]
[null,null,1,2,null,null,null,1,2]
[null,"John, 18 yr",{"$f":"TRIM(MID(SUBSTITUTE($B6,\",\",REPT(\" \",LEN($B6))),(C$5-1)*LEN($B6)+1,LEN($B6)))","v":"John"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\",\",REPT(\" \",LEN($B6))),(D$5-1)*LEN($B6)+1,LEN($B6)))","v":"18 yr"},null,null,"John, 18 yr"]
[null,"Frank, 16 yr",{"$f":"TRIM(MID(SUBSTITUTE($B7,\",\",REPT(\" \",LEN($B7))),(C$5-1)*LEN($B7)+1,LEN($B7)))","v":"Frank"},"16 yr",null,null,"Frank, 16 yr"]
[null,"William, 21 yr","William","21 yr",null,null,"William, 21 yr"]
[null,"Adam, 23 yr","Adam","23 yr",null,null,"Adam, 23 yr"]
[null,"Rose, 17 yr","Rose","17 yr",null,null,"Rose, 17 yr"]
[null,"Anna, 15 yr","Anna","15 yr",null,null,"Anna, 15 yr"]
[null,"Robert, 19 yr","Robert","19 yr",null,null,"Robert, 19 yr"]
[null,"Henry, 22 yr","Henry","22 yr",null,null,"Henry, 22 yr"]
[null,"Elizabeth, 25 yr","Elizabeth","25 yr",null,null,"Elizabeth, 25 yr"]
[null,"Arthur, 20 yr","Arthur","20 yr",null,null,"Arthur, 20 yr"]

{"sheet":"Combining Functions","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Inserting FIND, LEFT, LEN, MID and RIGHT Functions",null,null,null,null,"Do It Yourself"]
[]
[null,"Name, Age","Name","Age",null,null,"Name, Age","Name","Age"]
[null,"John, 18 yr",{"$f":"LEFT(B5,SEARCH(\", \",B5,1)-1)","v":"John"},{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\",\",B5))","v":" 18 yr"},null,null,"John, 18 yr",{"$f":"LEFT(G5,SEARCH(\", \",G5,1)-1)","v":"John"},{"$f":"RIGHT(G5,LEN(G5)-SEARCH(\",\",G5))","v":" 18 yr"}]
[null,"Frank, 16 yr",{"$f":"LEFT(B6,SEARCH(\", \",B6,1)-1)","v":"Frank"},{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\",\",B6))","v":" 16 yr"},null,null,"Frank, 16 yr",{"$f":"LEFT(G6,SEARCH(\", \",G6,1)-1)","v":"Frank"},{"$f":"RIGHT(G6,LEN(G6)-SEARCH(\",\",G6))","v":" 16 yr"}]
[null,"William, 21 yr","William"," 21 yr",null,null,"William, 21 yr","William"," 21 yr"]
[null,"Adam, 23 yr","Adam"," 23 yr",null,null,"Adam, 23 yr","Adam"," 23 yr"]
[null,"Rose, 17 yr","Rose"," 17 yr",null,null,"Rose, 17 yr","Rose"," 17 yr"]
[null,"Anna, 15 yr","Anna"," 15 yr",null,null,"Anna, 15 yr","Anna"," 15 yr"]
[null,"Robert, 19 yr","Robert"," 19 yr",null,null,"Robert, 19 yr","Robert"," 19 yr"]
[null,"Henry, 22 yr","Henry"," 22 yr",null,null,"Henry, 22 yr","Henry"," 22 yr"]
[null,"Elizabeth, 25 yr","Elizabeth"," 25 yr",null,null,"Elizabeth, 25 yr","Elizabeth"," 25 yr"]
[null,"Arthur, 20 yr","Arthur"," 20 yr",null,null,"Arthur, 20 yr","Arthur"," 20 yr"]

{"sheet":"Text to Column","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using Text to Columns Feature",null,null,null,null,"Do It Yourself"]
[]
[null,"Name, Age","Name","Age",null,null,"Name, Age","Name","Age"]
[null,"John, 18 yr","John"," 18 yr",null,null,"John, 18 yr","John"," 18 yr"]
[null,"Frank, 16 yr","Frank"," 16 yr",null,null,"Frank, 16 yr","Frank"," 16 yr"]
[null,"William, 21 yr","William"," 21 yr",null,null,"William, 21 yr","William"," 21 yr"]
[null,"Adam, 23 yr","Adam"," 23 yr",null,null,"Adam, 23 yr","Adam"," 23 yr"]
[null,"Rose, 17 yr","Rose"," 17 yr",null,null,"Rose, 17 yr","Rose"," 17 yr"]
[null,"Anna, 15 yr","Anna"," 15 yr",null,null,"Anna, 15 yr","Anna"," 15 yr"]
[null,"Robert, 19 yr","Robert"," 19 yr",null,null,"Robert, 19 yr","Robert"," 19 yr"]
[null,"Henry, 22 yr","Henry"," 22 yr",null,null,"Henry, 22 yr","Henry"," 22 yr"]
[null,"Elizabeth, 25 yr","Elizabeth"," 25 yr",null,null,"Elizabeth, 25 yr","Elizabeth"," 25 yr"]
[null,"Arthur, 20 yr","Arthur"," 20 yr",null,null,"Arthur, 20 yr","Arthur"," 20 yr"]

{"sheet":"Flash Fill","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Implementing Flash Fill Feature",null,null,null,null,"Do It Yourself"]
[]
[null,"Name, Age","Name","Age",null,null,"Name, Age","Name","Age"]
[null,"John, 18 yr","John",null,null,null,"John, 18 yr","John"]
[null,"Frank, 16 yr","Frank",null,null,null,"Frank, 16 yr","Frank"]
[null,"William, 21 yr","William",null,null,null,"William, 21 yr","William"]
[null,"Adam, 23 yr","Adam",null,null,null,"Adam, 23 yr","Adam"]
[null,"Rose, 17 yr","Rose",null,null,null,"Rose, 17 yr","Rose"]
[null,"Anna, 15 yr","Anna",null,null,null,"Anna, 15 yr","Anna"]
[null,"Robert, 19 yr","Robert",null,null,null,"Robert, 19 yr","Robert"]
[null,"Henry, 22 yr","Henry",null,null,null,"Henry, 22 yr","Henry"]
[null,"Elizabeth, 25 yr","Elizabeth",null,null,null,"Elizabeth, 25 yr","Elizabeth"]
[null,"Arthur, 20 yr","Arthur",null,null,null,"Arthur, 20 yr","Arthur"]

{"sheet":"VBA","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Applying VBA Code",null,null,null,null,"Do It Yourself"]
[]
[null,"Name, Age","Name","Age",null,null,"Name, Age","Name","Age"]
[null,"John, 18 yr","John"," 18 yr",null,null,"John, 18 yr","John"," 18 yr"]
[null,"Frank, 16 yr","Frank"," 16 yr",null,null,"Frank, 16 yr","Frank"," 16 yr"]
[null,"William, 21 yr","William"," 21 yr",null,null,"William, 21 yr","William"," 21 yr"]
[null,"Adam, 23 yr","Adam"," 23 yr",null,null,"Adam, 23 yr","Adam"," 23 yr"]
[null,"Rose, 17 yr","Rose"," 17 yr",null,null,"Rose, 17 yr","Rose"," 17 yr"]
[null,"Anna, 15 yr","Anna"," 15 yr",null,null,"Anna, 15 yr","Anna"," 15 yr"]
[null,"Robert, 19 yr","Robert"," 19 yr",null,null,"Robert, 19 yr","Robert"," 19 yr"]
[null,"Henry, 22 yr","Henry"," 22 yr",null,null,"Henry, 22 yr","Henry"," 22 yr"]
[null,"Elizabeth, 25 yr","Elizabeth"," 25 yr",null,null,"Elizabeth, 25 yr","Elizabeth"," 25 yr"]
[null,"Arthur, 20 yr","Arthur"," 20 yr",null,null,"Arthur, 20 yr","Arthur"," 20 yr"]