{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sample Datasheet","Changing Number Format","VALUE Function","SUBSTITUTE Function","RIGHT and LEN Functions","REPLACE Function","Text to Columns","Flash Fill","VBA Code","Summary","Add Currency Symbol"],"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":"Sample Datasheet","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount"]
[null,"Dominic",5991]
[null,"Avram",8371]
[null,"Julian",7599]
[null,"Orlando",8405]
[null,"Barry",8517]
[null,"Adrian",7930]
[null,"Kato",7112]
[null,"Clark",6433]

{"sheet":"Changing Number Format","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount"]
[null,"Dominic",5991]
[null,"Avram",8371]
[null,"Julian",7599]
[null,"Orlando",8405]
[null,"Barry",8517]
[null,"Adrian",7930]
[null,"Kato",7112]
[null,"Clark",6433]

{"sheet":"VALUE Function","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,{"$f":"VALUE(C6)","v":5991}]
[null,"Avram",8371,{"$f":"VALUE(C7)","v":8371}]
[null,"Julian",7599,7599]
[null,"Orlando",8405,8405]
[null,"Barry",8517,8517]
[null,"Adrian",7930,7930]
[null,"Kato",7112,7112]
[null,"Clark",6433,6433]

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,{"$f":"SUBSTITUTE(C6,\"$\",\"\")","v":"5991"}]
[null,"Avram",8371,{"$f":"SUBSTITUTE(C7,\"$\",\"\")","v":"8371"}]
[null,"Julian",7599,"7599"]
[null,"Orlando",8405,"8405"]
[null,"Barry",8517,"8517"]
[null,"Adrian",7930,"7930"]
[null,"Kato",7112,"7112"]
[null,"Clark",6433,"6433"]

{"sheet":"RIGHT and LEN Functions","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,{"$f":" RIGHT(C6,LEN(C6))","v":"5991"}]
[null,"Avram",8371,{"$f":" RIGHT(C7,LEN(C7))","v":"8371"}]
[null,"Julian",7599,"7599"]
[null,"Orlando",8405,"8405"]
[null,"Barry",8517,"8517"]
[null,"Adrian",7930,"7930"]
[null,"Kato",7112,"7112"]
[null,"Clark",6433,"6433"]

{"sheet":"REPLACE Function","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,{"$f":"REPLACE(C6,1,0,\"\")","v":"5991"}]
[null,"Avram",8371,{"$f":"REPLACE(C7,1,0,\"\")","v":"8371"}]
[null,"Julian",7599,"7599"]
[null,"Orlando",8405,"8405"]
[null,"Barry",8517,"8517"]
[null,"Adrian",7930,"7930"]
[null,"Kato",7112,"7112"]
[null,"Clark",6433,"6433"]

{"sheet":"Text to Columns","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,5991]
[null,"Avram",8371,8371]
[null,"Julian",7599,7599]
[null,"Orlando",8405,8405]
[null,"Barry",8517,8517]
[null,"Adrian",7930,7930]
[null,"Kato",7112,7112]
[null,"Clark",6433,6433]

{"sheet":"Flash Fill","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount","Savings Value"]
[null,"Dominic",5991,5991]
[null,"Avram",8371,8371]
[null,"Julian",7599,7599]
[null,"Orlando",8405,8405]
[null,"Barry",8517,8517]
[null,"Adrian",7930,7930]
[null,"Kato",7112,7112]
[null,"Clark",6433,6433]

{"sheet":"VBA Code","index":8,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount"]
[null,"Dominic",5991]
[null,"Avram",8371]
[null,"Julian",7599]
[null,"Orlando",8405]
[null,"Barry",8517]
[null,"Adrian",7930]
[null,"Kato",7112]
[null,"Clark",6433]

{"sheet":"Summary","index":9,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[2,1,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3]]}
[]
[]
[null,"Removing Currency Symbol"]
[]
[null,"Name","Savings Amount"]
[null,"Dominic",5991]
[null,"Avram",8371]
[null,"Julian",7599]
[null,"Orlando",8405]
[null,"Barry",8517]
[null,"Adrian",7930]
[null,"Kato",7112]
[null,"Clark",6433]
[]
[null,"Method","Outcome","Formula"]
[null,"Changing Cell Format",5991]
[null,"VALUE Function",{"$f":"VALUE(C6)","v":5991},{"$f":"_xlfn.FORMULATEXT(C17)","v":"=VALUE(C6)"}]
[null,"SUBSTITUTE Function",{"$f":"SUBSTITUTE(C6,\"$\",\"\")","v":"5991"},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=SUBSTITUTE(C6,\"$\",\"\")"}]
[null,"RIGHT and LEN Functions",{"$f":" RIGHT(C6,LEN(C6))","v":"5991"},"= RIGHT(C6,LEN(C6))"]
[null,"REPLACE Function",{"$f":"REPLACE(C6,1,0,\"\")","v":"5991"},"=REPLACE(C6,1,0,\"\")"]
[null,"Text to Columns Feature",5991]
[null,"Flash Fill",5991]
[null,"VBA Code",5991]

{"sheet":"Add Currency Symbol","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Currency Symbol"]
[]
[null,"Name","Savings Amount"]
[null,"Dominic",5991]
[null,"Avram",8371]
[null,"Julian",7599]
[null,"Orlando",8405]
[null,"Barry",8517]
[null,"Adrian",7930]
[null,"Kato",7112]
[null,"Clark",6433]