{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SEARCH_L_R","First_SP","Last_SP","N-th","UDF","Flash_Fill"],"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":"SEARCH_L_R","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"RIGHT, LEN & SEARCH Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Result",null,null,null,null,null,null,null,null,"Name","Result"]
[null,"Andrew Yang",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\" \",B5))","v":"Yang"},null,null,null,null,null,null,null,null,"Andrew Yang"]
[null,"Adam Smith",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\" \",B6))","v":"Smith"},null,null,null,null,null,null,null,null,"Adam Smith"]
[null,"Michel Clark","Clark",null,null,null,null,null,null,null,null,"Michel Clark"]
[null,"Emily Williams","Williams",null,null,null,null,null,null,null,null,"Emily Williams"]
[null,"June Brown","Brown",null,null,null,null,null,null,null,null,"June Brown"]
[null,"John Miller","Miller",null,null,null,null,null,null,null,null,"John Miller"]

{"sheet":"First_SP","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"RIGHT, LEN & FIND Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Teacher 33",{"$f":"RIGHT(B5,LEN(B5)-FIND(\" \",B5))","v":"Teacher 33"},null,null,null,null,null,null,null,null,"Andrew Teacher 33"]
[null,"Adam Engineer 50",{"$f":"RIGHT(B6,LEN(B6)-FIND(\" \",B6))","v":"Engineer 50"},null,null,null,null,null,null,null,null,"Adam Engineer 50"]
[null,"Michel Actor 35","Actor 35",null,null,null,null,null,null,null,null,"Michel Actor 35"]
[null,"June Doctor 45","Doctor 45",null,null,null,null,null,null,null,null,"June Doctor 45"]
[null,"John Architect 40","Architect 40",null,null,null,null,null,null,null,null,"John Architect 40"]
[null,"Mark Chef 44","Chef 44",null,null,null,null,null,null,null,null,"Mark Chef 44"]

{"sheet":"Last_SP","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Delete Text before Last Space",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Teacher 33",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"#\",SUBSTITUTE(B5,\" \",\"#\",LEN(B5)-LEN(SUBSTITUTE(B5,\" \",\"\")))))","v":"33"},null,null,null,null,null,null,null,null,"Andrew Teacher 33"]
[null,"Adam Engineer 50",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\"#\",SUBSTITUTE(B6,\" \",\"#\",LEN(B6)\n-LEN(SUBSTITUTE(B6,\" \",\"\")))))","v":"50"},null,null,null,null,null,null,null,null,"Adam Engineer 50"]
[null,"Michel Actor 35","35",null,null,null,null,null,null,null,null,"Michel Actor 35"]
[null,"June Doctor 45","45",null,null,null,null,null,null,null,null,"June Doctor 45"]
[null,"John Architect 40","40",null,null,null,null,null,null,null,null,"John Architect 40"]
[null,"Mark Chef 44","44",null,null,null,null,null,null,null,null,"Mark Chef 44"]

{"sheet":"N-th","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Delete Text before N-th Space",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Teacher 33 M",{"$f":"RIGHT(SUBSTITUTE(B5,\" \",\"#\",2),LEN(B5)-FIND(\"#\",SUBSTITUTE(B5,\" \",\"#\",2)))","v":"33 M"},null,null,null,null,null,null,null,null,"Andrew Teacher 33 M"]
[null,"Emma Engineer 50 F",{"$f":"RIGHT(SUBSTITUTE(B6,\" \",\"#\",2),LEN(B6)-FIND(\"#\",\nSUBSTITUTE(B6,\" \",\"#\",2)))","v":"50 F"},null,null,null,null,null,null,null,null,"Emma Engineer 50 F"]
[null,"Michel Actor 35 M","35 M",null,null,null,null,null,null,null,null,"Michel Actor 35 M"]
[null,"June Doctor 45 F","45 F",null,null,null,null,null,null,null,null,"June Doctor 45 F"]
[null,"John Architect 40 M","40 M",null,null,null,null,null,null,null,null,"John Architect 40 M"]
[null,"Mark Chef 44 M","44 M",null,null,null,null,null,null,null,null,"Mark Chef 44 M"]

{"sheet":"UDF","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of VBA UDF",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data","Result",null,null,null,null,null,null,null,null,"Data","Result"]
[null,"Andrew Teacher 33 M",{"$f":"DeleteText(B5,\" \",2,TRUE)","v":"33 M"},null,null,null,null,null,null,null,null,"Andrew Teacher 33 M"]
[null,"Emma Engineer 50 F",{"$f":"DeleteText(B6,\" \",2,TRUE)","v":"50 F"},null,null,null,null,null,null,null,null,"Emma Engineer 50 F"]
[null,"Michel Actor 35 M",{"$f":"DeleteText(B7,\" \",2,TRUE)","v":"35 M"},null,null,null,null,null,null,null,null,"Michel Actor 35 M"]
[null,"June Doctor 45 F",{"$f":"DeleteText(B8,\" \",2,TRUE)","v":"45 F"},null,null,null,null,null,null,null,null,"June Doctor 45 F"]
[null,"John Architect 40 M",{"$f":"DeleteText(B9,\" \",2,TRUE)","v":"40 M"},null,null,null,null,null,null,null,null,"John Architect 40 M"]
[null,"Mark Chef 44 M",{"$f":"DeleteText(B10,\" \",2,TRUE)","v":"44 M"},null,null,null,null,null,null,null,null,"Mark Chef 44 M"]

{"sheet":"Flash_Fill","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Flash Fill"]
[]
[null,"Data","Result"]
[null,"Andrew Teacher","Teacher"]
[null,"Adam Engineer","Engineer"]
[null,"Michel Actor","Actor"]
[null,"June Doctor","Doctor"]
[null,"John Architect","Architect"]
[null,"Mark Chef","Chef"]