{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["MID & FIND","RIGHT LEN MID","SUBSTITUTE","RIGHT, SEARCH","RIGHT, REPT","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":"MID & FIND","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using MID & FIND Functions"]
[]
[null,"Text","Result"]
[null,"Hello-World",{"$f":"MID(B5,FIND(\"-\",B5)+1,LEN(B5))","v":"World"}]
[null,"Fire-Hydrant",{"$f":"MID(B6,FIND(\"-\",B6)+1,LEN(B6))","v":"Hydrant"}]
[null,"Microsoft-Excel 365","Excel 365"]
[null,"First Text -Final Text",{"$f":"MID(B8,FIND(\"-\",B8)+1,LEN(B8))","v":"Final Text"}]
[null,"Xn670-Rg56","Rg56"]

{"sheet":"RIGHT LEN MID","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using RIGHT, LEN &MID Functions"]
[]
[null,"Text","Result"]
[null,"Hello-World",{"$f":"RIGHT(B5,LEN(B5)-FIND(\"-\",B5))","v":"World"},null,null,null,null,null,null,{"$f":"LEFT(B5,FIND(\"-\",B5))","v":"Hello-"},{"$f":"SUBSTITUTE(B5,LEFT(B5,FIND(\"-\",B5)),\"\")","v":"World"}]
[null,"Fire-Hydrant",{"$f":"RIGHT(B6,LEN(B6)-FIND(\"-\",B6))","v":"Hydrant"},null,null,null,null,null,null,{"$f":"LEFT(B6,FIND(\"-\",B6))","v":"Fire-"},{"$f":"SUBSTITUTE(B6,LEFT(B6,FIND(\"-\",B6)),\"\")","v":"Hydrant"}]
[null,"Microsoft-Excel 365","Excel 365",null,null,null,null,null,null,{"$f":"LEFT(B7,FIND(\"-\",B7))","v":"Microsoft-"},{"$f":"SUBSTITUTE(B7,LEFT(B7,FIND(\"-\",B7)),\"\")","v":"Excel 365"}]
[null,"First Text -Final Text","Final Text",null,null,null,null,null,null,{"$f":"LEFT(B8,FIND(\"-\",B8))","v":"First Text -"},{"$f":"SUBSTITUTE(B8,LEFT(B8,FIND(\"-\",B8)),\"\")","v":"Final Text"}]
[null,"Xn670-Rg56","Rg56",null,null,null,null,null,null,{"$f":"LEFT(B9,FIND(\"-\",B9))","v":"Xn670-"},{"$f":"SUBSTITUTE(B9,LEFT(B9,FIND(\"-\",B9)),\"\")","v":"Rg56"}]

{"sheet":"SUBSTITUTE","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using LEFT, FIND & SUBSTITUTE Functions"]
[]
[null,"Text","Extract Text After","Result"]
[null,"Hello@World","@",{"$f":"SUBSTITUTE(B5,LEFT(B5,FIND(C5,B5)),\"\")","v":"World"}]
[null,"Fire-Hydrant","-",{"$f":"SUBSTITUTE(B6,LEFT(B6,FIND(C6,B6)),\"\")","v":"Hydrant"}]
[null,"Microsoft#Excel 365","#","Excel 365"]
[null,"First Text %Final Text","%","Final Text"]
[null,"Xn670&Rg56","&","Rg56"]

{"sheet":"RIGHT, SEARCH","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RIGHT, SEARCH & SUBSTITUTE Functions"]
[]
[null,"Text","Extract Text After","Result"]
[null,"Hello@World","@",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"#\",SUBSTITUTE(B5,C5,\"#\",LEN(B5)-LEN(SUBSTITUTE(B5,C5,\"\")))))","v":"World"}]
[null,"Fire-Hydrant","-",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\"#\",SUBSTITUTE(B6,C6,\"#\",LEN(B6)-LEN(SUBSTITUTE(B6,C6,\"\")))))","v":"Hydrant"}]
[null,"Microsoft#Excel 365","#",{"$f":"RIGHT(B7,LEN(B7)-SEARCH(\"#\",SUBSTITUTE(B7,C7,\"#\",LEN(B7)-LEN(SUBSTITUTE(B7,C7,\"\")))))","v":"Excel 365"}]
[null,"First Text %Final Text","%","Final Text"]
[null,"Xn670&Rg56","&","Rg56"]

{"sheet":"RIGHT, REPT","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RIGHT, REPT & SUBSTITUTE Functions"]
[]
[null,"Text","Extract Text After","Result"]
[null,"Hello@World","@",{"$f":"TRIM(RIGHT(SUBSTITUTE(B5,C5,REPT(\" \",LEN(B5))),LEN(B5)))","v":"World"}]
[null,"Fire-Hydrant","-",{"$f":"TRIM(RIGHT(SUBSTITUTE(B6,C6,REPT(\" \",LEN(B6))),LEN(B6)))","v":"Hydrant"}]
[null,"Microsoft#Excel 365","#",{"$f":"TRIM(RIGHT(SUBSTITUTE(B7,C7,REPT(\" \",LEN(B7))),LEN(B7)))","v":"Excel 365"}]
[null,"First Text %Final Text","%","Final Text"]
[null,"Xn670&Rg56","&","Rg56"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Codes"]
[]
[null,"Text","Result"]
[null,"Hello-World","World"]
[null,"Fire-Hydrant","Hydrant"]
[null,"Microsoft-Excel 365","Excel 365"]
[null,"First Text -Final Text","Final Text"]
[null,"Xn670-Rg56","Rg56"]