{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Right-Function","Trim_Functions","Excel_O_365_XLookup","Filter_XML","Flash_FILL","VBA_Macro"],"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":"Right-Function","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,Haggins, CEO",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"#\",SUBSTITUTE(B5,\" \",\"#\",LEN(B5)-LEN(SUBSTITUTE(B5,\" \",\"\")))))","v":"CEO"}]
[null,"Tim Scott, CFO",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\"#\",SUBSTITUTE(B6,\" \",\"#\",LEN(B6)-LEN(SUBSTITUTE(B6,\" \",\"\")))))","v":"CFO"}]
[null,"CRAIG Harris, CMO","CMO"]
[null,"Amanda, Journy, VP-Finance","VP-Finance"]
[null,"Amy Patillo, VP-Marketing","VP-Marketing"]
[null,"Blake, Estrada, VP-IT","VP-IT"]
[null,"Amy, Dennis , Admin","Admin"]

{"sheet":"Trim_Functions","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,haggins, *CEO",{"$f":"TRIM(RIGHT(SUBSTITUTE(B5,\" \",REPT(\" \",LEN(B5))),LEN(B5)))","v":"*CEO"},{"$f":"TRIM(RIGHT(SUBSTITUTE(B5,\"*\",REPT(\" \",LEN(B5))),LEN(B5)))","v":"CEO"}]
[null,"Tim Scott, CFO",{"$f":"TRIM(RIGHT(SUBSTITUTE(B6,\" \",REPT(\" \",LEN(B6))),LEN(B6)))","v":"CFO"}]
[null,"CRAIG Harris, CMO",{"$f":"TRIM(RIGHT(SUBSTITUTE(B7,\" \",REPT(\" \",LEN(B7))),LEN(B7)))","v":"CMO"}]
[null,"Amanda, Journy, VP-Finance","VP-Finance"]
[null,"Amy Patillo, VP-Marketing","VP-Marketing"]
[null,"Blake,Estrada, VP-IT","VP-IT"]
[null,"Amy, Dennis , Admin","Admin"]

{"sheet":"Excel_O_365_XLookup","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,haggins, CEO",{"$f":"REPLACE(B5,1,_xlfn.XLOOKUP(\" \",MID(B5,_xlfn.SEQUENCE(LEN(B5)),1),_xlfn.SEQUENCE(LEN(B5)),,0,-1),\"\")","v":"CEO"}]
[null,"Tim Scott, CFO",{"$f":"REPLACE(B6,1,_xlfn.XLOOKUP(\" \",MID(B6,_xlfn.SEQUENCE(LEN(B6)),1),_xlfn.SEQUENCE(LEN(B6)),,0,-1),\"\")","v":"CFO"}]
[null,"CRAIG Harris, CMO",{"$f":"REPLACE(B7,1,_xlfn.XLOOKUP(\" \",MID(B7,_xlfn.SEQUENCE(LEN(B7)),1),_xlfn.SEQUENCE(LEN(B7)),,0,-1),\"\")","v":"CMO"}]
[null,"Amanda, Journy, VP-Finance",{"$f":"REPLACE(B8,1,_xlfn.XLOOKUP(\" \",MID(B8,_xlfn.SEQUENCE(LEN(B8)),1),_xlfn.SEQUENCE(LEN(B8)),,0,-1),\"\")","v":"VP-Finance"}]
[null,"Amy Patillo, VP-Marketing",{"$f":"REPLACE(B9,1,_xlfn.XLOOKUP(\" \",MID(B9,_xlfn.SEQUENCE(LEN(B9)),1),_xlfn.SEQUENCE(LEN(B9)),,0,-1),\"\")","v":"VP-Marketing"}]
[null,"Blake,Estrada, VP-IT",{"$f":"REPLACE(B10,1,_xlfn.XLOOKUP(\" \",MID(B10,_xlfn.SEQUENCE(LEN(B10)),1),_xlfn.SEQUENCE(LEN(B10)),,0,-1),\"\")","v":"VP-IT"}]
[null,"Amy, Dennis , Admin",{"$f":"REPLACE(B11,1,_xlfn.XLOOKUP(\" \",MID(B11,_xlfn.SEQUENCE(LEN(B11)),1),_xlfn.SEQUENCE(LEN(B11)),,0,-1),\"\")","v":"Admin"}]

{"sheet":"Filter_XML","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,haggins, CEO",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B5,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"CEO"}]
[null,"Tim Scott, CFO",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B6,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"CFO"}]
[null,"CRAIG Harris, CMO",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B7,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"CMO"}]
[null,"Amanda, Journy, VP-Finance",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B8,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"VP-Finance"}]
[null,"Amy Patillo, VP-Marketing",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B9,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"VP-Marketing"}]
[null,"Blake,Estrada, VP-IT",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B10,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"VP-IT"}]
[null,"Amy, Dennis , Admin",{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(B11,\" \",\"</s><s>\")&\"</s></t>\",\"//s[last()]\")","v":"Admin"}]

{"sheet":"Flash_FILL","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,haggins, CEO","CEO"]
[null,"Tim Scott, CFO","CFO"]
[null,"CRAIG Harris, CMO","CMO"]
[null,"Amanda, Journy, VP-Finance","VP-Finance"]
[null,"Amy Patillo, VP-Marketing","VP-Marketing"]
[null,"Blake, Estrada, VP-IT","VP-IT"]
[null,"Amy, Dennis , Admin","Admin"]

{"sheet":"VBA_Macro","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Text After Last Space"]
[]
[null,"Name & Designation ","Designation"]
[null,"Jeffery,haggins, CEO"," CEO"]
[null,"Tim Scott, CFO"," CFO"]
[null,"CRAIG Harris, CMO"," CMO"]
[null,"Amanda, Journy, VP-Finance"," VP-Finance"]
[null,"Amy Patillo, VP-Marketing"," VP-Marketing"]
[null,"Blake, Estrada, VP-IT"," VP-IT"]
[null,"Amy, Dennis , Admin"," Admin"]