{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Find and Replace","LEN, SUBSTITUTE, FIND, and MID","REPT, SUBSTITUTE, RIGHT,TRIM","CHOOSECOLS, TEXTSPLIT","SUBSTITUTE,LEN, CHAR, FIND, MID","VBA with User Defined","VBA Code"],"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":"Find and Replace","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Find and Replace Feature",null,null,null,null,null,"Practise yourself"]
[]
[null,"File Path",null,null,null,null,null,"File Path"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby",null,null,null,null,null,"C:\\Users\\Public\\Pictures\\Deer baby"]
[null,"C:\\Users\\Public\\Downloads\\Bills for work",null,null,null,null,null,"C:\\Users\\Public\\Downloads\\Bills for work"]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball",null,null,null,null,null,"C:\\Users\\Public\\Documents\\Academic-Curveball"]
[null,"C:\\Users\\Public\\Music\\Coldplay",null,null,null,null,null,"C:\\Users\\Public\\Music\\Coldplay"]
[null,"C:\\Users\\Public\\Pictures\\tiger",null,null,null,null,null,"C:\\Users\\Public\\Pictures\\tiger"]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP",null,null,null,null,null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP"]
[null,"C:\\Users\\Public\\Downloads\\Project Work",null,null,null,null,null,"C:\\Users\\Public\\Downloads\\Project Work"]

{"sheet":"LEN, SUBSTITUTE, FIND, and MID","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of LEN, SUBSTITUTE, FIND, and MID Functions"]
[]
[null,"File Path","File Name"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby",{"$f":"MID(B5,FIND(\"*\",SUBSTITUTE(B5,\"\\\",\"*\",LEN(B5)-LEN(SUBSTITUTE(B5,\"\\\",\"\"))))+1,LEN(B5))","v":"Deer baby"}]
[null,"C:\\Users\\Public\\Downloads\\Bills for work",{"$f":"MID(B6,FIND(\"*\",SUBSTITUTE(B6,\"\\\",\"*\",LEN(B6)-LEN(SUBSTITUTE(B6,\"\\\",\"\"))))+1,LEN(B6))","v":"Bills for work"}]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball","Academic-Curveball"]
[null,"C:\\Users\\Public\\Music\\Coldplay","Coldplay"]
[null,"C:\\Users\\Public\\Pictures\\tiger","tiger"]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP","OSPP"]
[null,"C:\\Users\\Public\\Downloads\\Project Work","Project Work"]

{"sheet":"REPT, SUBSTITUTE, RIGHT,TRIM","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of REPT, SUBSTITUTE, RIGHT, and TRIM Functions"]
[]
[null,"File Path","File Name"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby",{"$f":"TRIM(RIGHT(SUBSTITUTE(B5,\"\\\",REPT(\" \",100)),99))","v":"Deer baby"}]
[null,"C:\\Users\\Public\\Downloads\\Bills for work",{"$f":"TRIM(RIGHT(SUBSTITUTE(B6,\"\\\",REPT(\" \",100)),99))","v":"Bills for work"}]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball","Academic-Curveball"]
[null,"C:\\Users\\Public\\Music\\Coldplay","Coldplay"]
[null,"C:\\Users\\Public\\Pictures\\tiger","tiger"]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP","OSPP"]
[null,"C:\\Users\\Public\\Downloads\\Project Work","Project Work"]

{"sheet":"CHOOSECOLS, TEXTSPLIT","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of CHOOSECOLS and TEXTSPLIT Functions"]
[]
[null,"File Path","File Name"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B5,\"\\\"),-1)","v":"Deer baby"}]
[null,"C:\\Users\\Public\\Downloads\\Bills for work",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B6,\"\\\"),-1)","v":"Bills for work"}]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B7,\"\\\"),-1)","v":"Academic-Curveball"}]
[null,"C:\\Users\\Public\\Music\\Coldplay",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B8,\"\\\"),-1)","v":"Coldplay"}]
[null,"C:\\Users\\Public\\Pictures\\tiger",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B9,\"\\\"),-1)","v":"tiger"}]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B10,\"\\\"),-1)","v":"OSPP"}]
[null,"C:\\Users\\Public\\Downloads\\Project Work",{"$f":"_xlfn.CHOOSECOLS(_xlfn.TEXTSPLIT(B11,\"\\\"),-1)","v":"Project Work"}]

{"sheet":"SUBSTITUTE,LEN, CHAR, FIND, MID","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of SUBSTITUTE, LEN, CHAR, FIND, MID, and IFERROR Functions"]
[]
[null,"File Path","File Name"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby.png",{"$f":"IFERROR(MID(B5,FIND(CHAR(1),SUBSTITUTE(B5,\"\\\",CHAR(1),LEN(B5)-LEN(SUBSTITUTE(B5,\"\\\",\"\"))))+1,FIND(CHAR(1),SUBSTITUTE(B5,\".\",CHAR(1),LEN(B5)-LEN(SUBSTITUTE(B5,\".\",\"\"))))-FIND(CHAR(1),SUBSTITUTE(B5,\"\\\",CHAR(1),LEN(B5)-LEN(SUBSTITUTE(B5,\"\\\",\"\"))))-1),\"\")","v":"Deer baby"}]
[null,"C:\\Users\\Public\\Downloads\\Bills for work.docx",{"$f":"IFERROR(MID(B6,FIND(CHAR(1),SUBSTITUTE(B6,\"\\\",CHAR(1),LEN(B6)-LEN(SUBSTITUTE(B6,\"\\\",\"\"))))+1,FIND(CHAR(1),SUBSTITUTE(B6,\".\",CHAR(1),LEN(B6)-LEN(SUBSTITUTE(B6,\".\",\"\"))))-FIND(CHAR(1),SUBSTITUTE(B6,\"\\\",CHAR(1),LEN(B6)-LEN(SUBSTITUTE(B6,\"\\\",\"\"))))-1),\"\")","v":"Bills for work"}]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball.pdf","Academic-Curveball"]
[null,"C:\\Users\\Public\\Music\\Coldplay.mp3","Coldplay"]
[null,"C:\\Users\\Public\\Pictures\\tiger.jpg","tiger"]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP.hml","OSPP"]
[null,"C:\\Users\\Public\\Downloads\\Project Work.doc","Project Work"]

{"sheet":"VBA with User Defined","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code with User Defined Function"]
[]
[null,"File Path","File Name"]
[null,"C:\\Users\\Public\\Pictures\\Deer baby",{"$f":"GetFileName(B5)","v":"Deer baby"}]
[null,"C:\\Users\\Public\\Downloads\\Bills for work",{"$f":"GetFileName(B6)","v":"Bills for work"}]
[null,"C:\\Users\\Public\\Documents\\Academic-Curveball",{"$f":"GetFileName(B7)","v":"Academic-Curveball"}]
[null,"C:\\Users\\Public\\Music\\Coldplay",{"$f":"GetFileName(B8)","v":"Coldplay"}]
[null,"C:\\Users\\Public\\Pictures\\tiger",{"$f":"GetFileName(B9)","v":"tiger"}]
[null,"C:\\Program Files\\Microsoft Office\\Office16\\OSPP",{"$f":"GetFileName(B10)","v":"OSPP"}]
[null,"C:\\Users\\Public\\Downloads\\Project Work",{"$f":"GetFileName(B11)","v":"Project Work"}]

{"sheet":"VBA Code","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA Code"]
[]
[null,"File Path"]
[null,"Deer baby"]
[null,"Bills for work"]
[null,"Academic-Curveball"]
[null,"Coldplay"]
[null,"tiger"]
[null,"OSPP"]
[null,"Project Work"]