{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TRUNC Function","Combination of LEFT & LEN","Combination of REPLACE & LEN","Excel Flash Fill","VBA Macro","VBA Function"],"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":"TRUNC Function","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Last Digit in Excel"]
[]
[null,"Random","Result"]
[null,42561,{"$f":"TRUNC(B5/10)","v":4256}]
[null,65421,{"$f":"TRUNC(B6/10)","v":6542}]
[null,69784,6978]
[null,98743,9874]
[null,36654,3665]

{"sheet":"Combination of LEFT & LEN","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Last Digit Using LEFT & LEN Function"]
[]
[null,"Random","Result"]
[null,42561,{"$f":"LEFT(B5,LEN(B5)-1)","v":"4256"}]
[null,65421,{"$f":"LEFT(B6,LEN(B6)-1)","v":"6542"}]
[null,69784,"6978"]
[null,98743,"9874"]
[null,36654,"3665"]

{"sheet":"Combination of REPLACE & LEN","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of REPLACE & LEN Function"]
[]
[null,"Random","Result"]
[null,42561,{"$f":"REPLACE(B5,LEN(B5),1,\"\")","v":"4256"}]
[null,65421,{"$f":"REPLACE(B6,LEN(B6),1,\"\")","v":"6542"}]
[null,69784,"6978"]
[null,98743,"9874"]
[null,36654,"3665"]

{"sheet":"Excel Flash Fill","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Excel Flash Fill to Remove Last Digit"]
[]
[null,"Random","Result"]
[null,42561,4256]
[null,65421,6542]
[null,69784,6978]
[null,98743,9874]
[null,36654,3665]

{"sheet":"VBA Macro","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA to Remove Last Digit"]
[]
[null,"Random Data"]
[null,4256]
[null,6542]
[null,6978]
[null,9874]
[null,3665]

{"sheet":"VBA Function","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA Function to Remove Last Digit"]
[]
[null,"Random","Result"]
[null,42561,{"$f":"RemoveLastDigit(B5,1)","v":"4256"}]
[null,65421,{"$f":"RemoveLastDigit(B6,1)","v":"6542"}]
[null,69784,{"$f":"RemoveLastDigit(B7,1)","v":"6978"}]
[null,98743,{"$f":"RemoveLastDigit(B8,1)","v":"9874"}]
[null,36654,{"$f":"RemoveLastDigit(B9,1)","v":"3665"}]