{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset Overview","Formula1","Formula2","Text to Columns","Flash Fill","Decimal Numbers","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":"Dataset Overview","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee & ID","Department"]
[null,"Mike 100","Marketing"]
[null,"Chris 102","Accounting"]
[null,"Paul 104","Sales"]
[null,"Andrew 106","IT"]
[null,"John 107","Marketing"]

{"sheet":"Formula1","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of RIGHT, LEN, MIN & FIND Functions"]
[]
[null,"Employee & ID","ID Number","Department"]
[null,"Mike 100",{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB5&\"0123456789\"))+1)","v":"100"},"Marketing"]
[null,"Chris 102",{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB6&\"0123456789\"))+1)","v":"102"},"Accounting"]
[null,"Paul 104",{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB7&\"0123456789\"))+1)","v":"104"},"Sales"]
[null,"Andrew 106",{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB8&\"0123456789\"))+1)","v":"106"},"IT"]
[null,"John 107",{"$f":"RIGHT(B9,LEN(B9)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB9&\"0123456789\"))+1)","v":"107"},"Marketing"]

{"sheet":"Formula2","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of LEFT, SUM, LEN & SUBSTITUTE Functions"]
[]
[null,"ID & Employee","ID Number","Department"]
[null,"100 Mike",{"$f":"LEFT(B5,SUM(LEN(B5)-LEN(SUBSTITUTE(B5,\n{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"100"},"Marketing"]
[null,"102 Chris",{"$f":"LEFT(B6,SUM(LEN(B6)-LEN(SUBSTITUTE(B6,\n{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"102"},"Accounting"]
[null,"104 Paul",{"$f":"LEFT(B7,SUM(LEN(B7)-LEN(SUBSTITUTE(B7,\n{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"104"},"Sales"]
[null,"106 Andrew",{"$f":"LEFT(B8,SUM(LEN(B8)-LEN(SUBSTITUTE(B8,\n{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"106"},"IT"]
[null,"107 John",{"$f":"LEFT(B9,SUM(LEN(B9)-LEN(SUBSTITUTE(B9,\n{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"107"},"Marketing"]

{"sheet":"Text to Columns","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"With 'Text to Columns' Feature"]
[]
[null,"Name","ID","Department"]
[null,"Mike",100,"Marketing"]
[null,"Chris",102,"Accounting"]
[null,"Paul",104,"Sales"]
[null,"Andrew",106,"IT"]
[null,"John",107,"Marketing"]

{"sheet":"Flash Fill","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"With Flash Fill"]
[]
[null,"Employee & ID","ID Number","Department"]
[null,"Mike 100 23 2","100 23 2","Marketing"]
[null,"Chris 102",102,"Accounting"]
[null,"Paul 104 54 1","104 54 1","Sales"]
[null,"Andrew 106",106,"IT"]
[null,"John 107 77 2","107 77 2","Marketing"]

{"sheet":"Decimal Numbers","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Separate Decimal Numbers"]
[]
[null,"Employee & ID","ID Number","Department"]
[null,"Mike100.01",{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB5&\"0123456789\"))+1)","v":"100.01"},"Marketing"]
[null,"Chris 102.02",{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB6&\"0123456789\"))+1)","v":"102.02"},"Accounting"]
[null,"Paul104.04",{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB7&\"0123456789\"))+1)","v":"104.04"},"Sales"]
[null,"Andrew 106.06",{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB8&\"0123456789\"))+1)","v":"106.06"},"IT"]
[null,"John107.07",{"$f":"RIGHT(B9,LEN(B9)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},\nB9&\"0123456789\"))+1)","v":"107.07"},"Marketing"]

{"sheet":"VBA","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"With VBA"]
[]
[null,"Employee & ID","ID Number","Department"]
[null,"Mike100",{"$f":"SeparateNumbers(B5,TRUE)","v":"100"},"Marketing"]
[null,"Chris102",{"$f":"SeparateNumbers(B6,TRUE)","v":"102"},"Accounting"]
[null,"Pa104ul",{"$f":"SeparateNumbers(B7,TRUE)","v":"104"},"Sales"]
[null,"Andrew 106",{"$f":"SeparateNumbers(B8,TRUE)","v":"106"},"IT"]
[null,"107 John",{"$f":"SeparateNumbers(B9,TRUE)","v":"107"},"Marketing"]