{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Flash fill","Initial Dataset","LEFT & LEN"," MID & LEN","REPLACE","SUBSTITUTE","VBA","trunc_function","Sheet8"],"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":"Flash fill","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327 KLX","ABC327"]
["ABC328 KLX","ABC328"]
["ABC329 KLX","ABC329"]
["ABC330 KLX","ABC330"]
["ABC331 KLX","ABC331"]
["ABC332 KLX","ABC332"]
["ABC333 KLX","ABC333"]
["ABC334 KLX","ABC334"]
["ABC335 KLX","ABC335"]

{"sheet":"Initial Dataset","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX"]
["ABC328KLX"]
["ABC329KLX"]
["ABC350KLX"]
["ABC331KLX"]
["ABC324KLX"]
["ABC333KLX"]
["ABC343KLX"]
["ABC349KLX"]

{"sheet":"LEFT & LEN","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX",{"$f":"LEFT(A2, LEN(A2) - 3)","v":"ABC327"}]
["ABC328KLX",{"$f":"LEFT(A3, LEN(A3) - 3)","v":"ABC328"}]
["ABC329KLX","ABC329"]
["ABC350KLX","ABC350"]
["ABC331KLX","ABC331"]
["ABC324KLX","ABC324"]
["ABC333KLX","ABC333"]
["ABC343KLX","ABC343"]
["ABC349KLX","ABC349"]

{"sheet":" MID & LEN","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX",{"$f":"MID(A2,1, LEN(A2) - 3)","v":"ABC327"}]
["ABC328KLX"]
["ABC329KLX"]
["ABC350KLX"]
["ABC331KLX"]
["ABC324KLX"]
["ABC333KLX"]
["ABC343KLX"]
["ABC349KLX"]

{"sheet":"REPLACE","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX",{"$f":"REPLACE(A2, LEN(A2)-2, 3, \"\")","v":"ABC327"}]
["ABC328KLX",{"$f":"REPLACE(A3, LEN(A3)-2, 3, \"\")","v":"ABC328"}]
["ABC329KLX","ABC329"]
["ABC350KLX","ABC350"]
["ABC331KLX","ABC331"]
["ABC324KLX","ABC324"]
["ABC333KLX","ABC333"]
["ABC343KLX","ABC343"]
["ABC349KLX","ABC349"]

{"sheet":"SUBSTITUTE","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX",{"$f":"SUBSTITUTE(A2, RIGHT(A2, 3), \"\")","v":"ABC327"}]
["ABC328KLX",{"$f":"SUBSTITUTE(A3, RIGHT(A3, 3), \"\")","v":"ABC328"}]
["ABC329KLX","ABC329"]
["ABC350KLX","ABC350"]
["ABC331KLX","ABC331"]
["ABC324KLX","ABC324"]
["ABC333KLX","ABC333"]
["ABC343KLX","ABC343"]
["ABC349KLX","ABC349"]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
["ABC327KLX",{"$f":"RemoveLastThreeDigits(A2)","v":"ABC327"}]
["ABC328KLX",{"$f":"RemoveLastThreeDigits(A3)","v":"ABC328"}]
["ABC329KLX",{"$f":"RemoveLastThreeDigits(A4)","v":"ABC329"}]
["ABC350KLX",{"$f":"RemoveLastThreeDigits(A5)","v":"ABC350"}]
["ABC331KLX",{"$f":"RemoveLastThreeDigits(A6)","v":"ABC331"}]
["ABC324KLX",{"$f":"RemoveLastThreeDigits(A7)","v":"ABC324"}]
["ABC333KLX",{"$f":"RemoveLastThreeDigits(A8)","v":"ABC333"}]
["ABC343KLX",{"$f":"RemoveLastThreeDigits(A9)","v":"ABC343"}]
["ABC349KLX",{"$f":"RemoveLastThreeDigits(A10)","v":"ABC349"}]

{"sheet":"trunc_function","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ID Number","Final ID Number"]
[300123,{"$f":"TRUNC(A2/1000,0)","v":300}]
[300124,{"$f":"TRUNC(A3/1000,0)","v":300}]
[300125,300]
[300126,300]
[300127,300]
[300128,300]
[300129,300]
[300130,300]
[300131,300]

{"sheet":"Sheet8","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}