{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset ","LEFT Function","Combined","MID Function","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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Truncating Text from Left"]
[]
[null,"Employee Name","Working Period"]
[null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021"]

{"sheet":"LEFT Function","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of LEFT Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee Name","Working Period","Starting Month",null,null,null,null,null,null,"Employee Name","Working Period","Starting Month"]
[null,"Steven","August, 2012 to December, 2017",{"$f":"LEFT(C5,3)","v":"Aug"},null,null,null,null,null,null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018",{"$f":"LEFT(C6,3)","v":"Mar"},null,null,null,null,null,null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020","Jan",null,null,null,null,null,null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020","Nov",null,null,null,null,null,null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021","Feb",null,null,null,null,null,null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018","Mar",null,null,null,null,null,null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019","Oct",null,null,null,null,null,null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018","Jun",null,null,null,null,null,null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021","Sep",null,null,null,null,null,null,"Joshua","September, 2014 to December, 2021"]

{"sheet":"Combined","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Combination of LEFT & LEN Functions",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee Name","Working Period","Truncated Text",null,null,null,null,null,null,"Employee Name","Working Period","Truncated Text"]
[null,"Steven","August, 2012 to December, 2017",{"$f":"LEFT(C5, LEN(C5) - 17)","v":"August, 2012 "},null,null,null,null,null,null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018",{"$f":"LEFT(C6, LEN(C6) - 17)","v":"March, 20"},null,null,null,null,null,null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020",{"$f":"LEFT(C7, LEN(C7) - 17)","v":"January, "},null,null,null,null,null,null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020","November, 201",null,null,null,null,null,null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021","February, 2011",null,null,null,null,null,null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018","March, 2015 ",null,null,null,null,null,null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019","October, 2011",null,null,null,null,null,null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018","June, 2013",null,null,null,null,null,null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021","September, 2014 ",null,null,null,null,null,null,"Joshua","September, 2014 to December, 2021"]

{"sheet":"MID Function","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of MID Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee Name","Working Period","Starting Month",null,null,null,null,null,null,"Employee Name","Working Period","Starting Month"]
[null,"Steven","August, 2012 to December, 2017",{"$f":"MID(C5,1,3)","v":"Aug"},null,null,null,null,null,null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018",{"$f":"MID(C6,1,3)","v":"Mar"},null,null,null,null,null,null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020","Jan",null,null,null,null,null,null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020","Nov",null,null,null,null,null,null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021","Feb",null,null,null,null,null,null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018","Mar",null,null,null,null,null,null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019","Oct",null,null,null,null,null,null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018","Jun",null,null,null,null,null,null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021","Sep",null,null,null,null,null,null,"Joshua","September, 2014 to December, 2021"]

{"sheet":"Flash Fill","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of Flash Fill Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee Name","Working Period","Starting Month",null,null,null,null,null,null,"Employee Name","Working Period","Starting Month"]
[null,"Steven","August, 2012 to December, 2017","Aug",null,null,null,null,null,null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018","Mar",null,null,null,null,null,null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020","Jan",null,null,null,null,null,null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020","Nov",null,null,null,null,null,null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021","Feb",null,null,null,null,null,null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018","Mar",null,null,null,null,null,null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019","Oct",null,null,null,null,null,null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018","Jun",null,null,null,null,null,null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021","Sep",null,null,null,null,null,null,"Joshua","September, 2014 to December, 2021"]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee Name","Working Period","Truncated Text",null,null,null,null,null,null,"Employee Name","Working Period","Truncated Text"]
[null,"Steven","August, 2012 to December, 2017",{"$f":"Truncate_Txt_frm_Left(C5,17)","v":"August, 2012 "},null,null,null,null,null,null,"Steven","August, 2012 to December, 2017"]
[null,"Morris","March, 2015 to April, 2018",{"$f":"Truncate_Txt_frm_Left(C6,17)","v":"March, 20"},null,null,null,null,null,null,"Morris","March, 2015 to April, 2018"]
[null,"John","January, 2011 to May, 2020",{"$f":"Truncate_Txt_frm_Left(C7,17)","v":"January, "},null,null,null,null,null,null,"John","January, 2011 to May, 2020"]
[null,"Jonathon","November, 2014 to August, 2020",{"$f":"Truncate_Txt_frm_Left(C8,17)","v":"November, 201"},null,null,null,null,null,null,"Jonathon","November, 2014 to August, 2020"]
[null,"Graham","February, 2011 to January, 2021",{"$f":"Truncate_Txt_frm_Left(C9,17)","v":"February, 2011"},null,null,null,null,null,null,"Graham","February, 2011 to January, 2021"]
[null,"Usman","March, 2015 to November, 2018",{"$f":"Truncate_Txt_frm_Left(C10,17)","v":"March, 2015 "},null,null,null,null,null,null,"Usman","March, 2015 to November, 2018"]
[null,"Valentina","October, 2011 to October, 2019",{"$f":"Truncate_Txt_frm_Left(C11,17)","v":"October, 2011"},null,null,null,null,null,null,"Valentina","October, 2011 to October, 2019"]
[null,"Ricardo","June, 2013 to October, 2018",{"$f":"Truncate_Txt_frm_Left(C12,17)","v":"June, 2013"},null,null,null,null,null,null,"Ricardo","June, 2013 to October, 2018"]
[null,"Joshua","September, 2014 to December, 2021",{"$f":"Truncate_Txt_frm_Left(C13,17)","v":"September, 2014 "},null,null,null,null,null,null,"Joshua","September, 2014 to December, 2021"]