{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Flash Fill","PROPER function","VBA","Power Query","Table2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Flash Fill","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Flash Fill",null,null,null,null,"For Practice"]
[]
[null,"Employee Name","Corrected Name",null,null,null,"Employee Name","Corrected Name"]
[null,"tom smith","Tom Smith",null,null,null,"tom smith"]
[null,"jhon keagy","Jhon Keagy",null,null,null,"jhon keagy"]
[null,"Mia divia yang","Mia Divia Yang",null,null,null,"Mia divia yang"]
[null,"willium c. ryan","Willium C. Ryan",null,null,null,"willium c. ryan"]
[null,"bob R. foster ","Bob R. Foster",null,null,null,"bob R. foster "]
[null,"Charles henry Hyatt","Charles Henry Hyatt",null,null,null,"Charles henry Hyatt"]

{"sheet":"PROPER function","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of PROPER Function",null,null,null,null,"For Practice"]
[]
[null,"Employee Name","Corrected Name",null,null,null,"Employee Name","Corrected Name"]
[null,"tom smith",{"$f":"PROPER(B5)","v":"Tom Smith"},null,null,null,"tom smith"]
[null,"jhon keagy",{"$f":"PROPER(B6)","v":"Jhon Keagy"},null,null,null,"jhon keagy"]
[null,"Mia divia yang","Mia Divia Yang",null,null,null,"Mia divia yang"]
[null,"willium c. ryan","Willium C. Ryan",null,null,null,"willium c. ryan"]
[null,"bob R. foster ","Bob R. Foster ",null,null,null,"bob R. foster "]
[null,"Charles henry Hyatt","Charles Henry Hyatt",null,null,null,"Charles henry Hyatt"]

{"sheet":"VBA","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA",null,null,null,null,"For Practice"]
[]
[null,"Employee Name",null,null,null,null,"Employee Name"]
[null,"Tom Smith",null,null,null,null,"tom smith"]
[null,"Jhon Keagy",null,null,null,null,"jhon keagy"]
[null,"Mia Divia Yang",null,null,null,null,"Mia divia yang"]
[null,"Willium C. Ryan",null,null,null,null,"willium c. ryan"]
[null,"Bob R. Foster ",null,null,null,null,"bob R. foster "]
[null,"Charles Henry Hyatt",null,null,null,null,"Charles henry Hyatt"]

{"sheet":"Power Query","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query"]
[]
[null,"Employee Name"]
[null,"tom smith"]
[null,"jhon keagy"]
[null,"Mia divia yang"]
[null,"willium c. ryan"]
[null,"bob R. foster "]
[null,"Charles henry Hyatt"]

{"sheet":"Table2","index":4,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Employee Name"]
["Tom Smith"]
["Jhon Keagy"]
["Mia Divia Yang"]
["Willium C. Ryan"]
["Bob R. Foster "]
["Charles Henry Hyatt"]