{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Find & Replace","Text_Numbers","Change_Custom_Number","Paste_Special","VALUE","Functions_Combination","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":"Find & Replace","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Find & Replace",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,"Data"]
[null,80,null,null,null,null,null,null,null,null,80]
[null,10,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,0]
[null,30,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,0]
[null,50,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,0]
[null,80,null,null,null,null,null,null,null,null,80]
[null,70,null,null,null,null,null,null,null,null,70]

{"sheet":"Text_Numbers","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Convert Text to Numbers",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,"Data"]
[null,2222,null,null,null,null,null,null,null,null,"002222"]
[null,10,null,null,null,null,null,null,null,null,"0010"]
[null,200,null,null,null,null,null,null,null,null,"000200"]
[null,30,null,null,null,null,null,null,null,null,"00030"]
[null,100,null,null,null,null,null,null,null,null,"00100"]
[null,50,null,null,null,null,null,null,null,null,"0050"]
[null,111,null,null,null,null,null,null,null,null,"0111"]
[null,80,null,null,null,null,null,null,null,null,"0080"]
[null,970,null,null,null,null,null,null,null,null,"000970"]

{"sheet":"Change_Custom_Number","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Custom Number Format",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,"Data"]
[null,2222,null,null,null,null,null,null,null,null,2222]
[null,10,null,null,null,null,null,null,null,null,10]
[null,200,null,null,null,null,null,null,null,null,200]
[null,30,null,null,null,null,null,null,null,null,30]
[null,100,null,null,null,null,null,null,null,null,100]
[null,50,null,null,null,null,null,null,null,null,50]
[null,111,null,null,null,null,null,null,null,null,111]
[null,80,null,null,null,null,null,null,null,null,80]
[null,70,null,null,null,null,null,null,null,null,70]

{"sheet":"Paste_Special","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Paste Special",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,"Data"]
[null,2222,null,null,null,null,null,null,null,null,2222]
[null,10,null,null,null,null,null,null,null,null,10]
[null,200,null,null,null,null,null,null,null,null,200]
[null,30,null,null,null,null,null,null,null,null,30]
[null,100,null,null,null,null,null,null,null,null,100]
[null,50,null,null,null,null,null,null,null,null,"0050"]
[null,111,null,null,null,null,null,null,null,null,"00111"]
[null,80,null,null,null,null,null,null,null,null,"080"]
[null,70,null,null,null,null,null,null,null,null,"00070"]

{"sheet":"VALUE","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of VALUE Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"With Leading 0","Without Leading 0",null,null,null,null,null,null,null,"With Leading 0","Without Leading 0"]
[null,2222,{"$f":"VALUE(B5)","v":2222},null,null,null,null,null,null,null,2222]
[null,10,{"$f":"VALUE(B6)","v":10},null,null,null,null,null,null,null,10]
[null,200,200,null,null,null,null,null,null,null,200]
[null,30,30,null,null,null,null,null,null,null,30]
[null,100,100,null,null,null,null,null,null,null,100]
[null,"0050",50,null,null,null,null,null,null,null,"0050"]
[null,"00111",111,null,null,null,null,null,null,null,"00111"]
[null,"080",80,null,null,null,null,null,null,null,"080"]
[null,"00070",70,null,null,null,null,null,null,null,"00070"]

{"sheet":"Functions_Combination","index":5,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of Combination of Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"With Leading Zero","Without Leading Zero",null,null,null,null,null,null,null,"With Leading Zero","Without Leading Zero"]
[null,"00ABCD",{"$f":"LEFT(SUBSTITUTE(B5,\"0\",\"\"),1)","v":"A"},null,null,null,null,null,null,null,"00ABCD"]
[null,"00EFG10",{"$f":"RIGHT(B6,LEN(B6)-FIND(LEFT(SUBSTITUTE(B6,\"0\",\"\"),1),B6)+1)","v":"EFG10"},null,null,null,null,null,null,null,"00EFG10"]
[null,"00YHJI","YHJI",null,null,null,null,null,null,null,"00YHJI"]
[null,"00HJ90","HJ90",null,null,null,null,null,null,null,"00HJ90"]
[null,"00GHJ100","GHJ100",null,null,null,null,null,null,null,"00GHJ100"]
[null,"00YUI50","YUI50",null,null,null,null,null,null,null,"00YUI50"]

{"sheet":"VBA","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,null,null,null,null,"Data"]
[null,2222,null,null,null,null,null,null,null,null,"002222"]
[null,10,null,null,null,null,null,null,null,null,"0010"]
[null,200,null,null,null,null,null,null,null,null,"000200"]
[null,30,null,null,null,null,null,null,null,null,"00030"]
[null,100,null,null,null,null,null,null,null,null,"00100"]
[null,50,null,null,null,null,null,null,null,null,"0050"]
[null,111,null,null,null,null,null,null,null,null,"0111"]
[null,80,null,null,null,null,null,null,null,null,"0080"]
[null,970,null,null,null,null,null,null,null,null,"000970"]