{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset-1","Numbers After Text","Numbers Preceding Text","Separate Decimal Numbers","Dataset-2","Using Flash Fill","Delimiter Option","Dataset-3","Fixed Width Feature","Power Query","VBA Code","Splitting Numbers","Dataset-4","Split Number into 2 Columns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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-1","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Microsoft Office Verisons"]
[]
[null,"Version"]
[null," Microsoft Office 95"]
[null," Microsoft Office 97"]
[null," Microsoft Office 2000"]
[null," Microsoft Office 2003"]
[null," Microsoft Office 2007"]
[null," Microsoft Office 2010"]
[null," Microsoft Office 2013"]
[null," Microsoft Office 2016"]
[null," Microsoft Office 2019"]

{"sheet":"Numbers After Text","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Separating Numbers After Text",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Version","Year",null,null,null,null,null,null,null,null,"Version","Year"]
[null,"Microsoft Office 95",{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))+1)","v":"95"},null,null,null,null,null,null,null,null," Microsoft Office 95"]
[null,"Microsoft Office 97",{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))+1)","v":"97"},null,null,null,null,null,null,null,null," Microsoft Office 97"]
[null," Microsoft Office 2000",{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))+1)","v":"2000"},null,null,null,null,null,null,null,null," Microsoft Office 2000"]
[null," Microsoft Office 2003",{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))+1)","v":"2003"},null,null,null,null,null,null,null,null," Microsoft Office 2003"]
[null," Microsoft Office 2007",{"$f":"RIGHT(B9,LEN(B9)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\"))+1)","v":"2007"},null,null,null,null,null,null,null,null," Microsoft Office 2007"]
[null," Microsoft Office 2010",{"$f":"RIGHT(B10,LEN(B10)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\"))+1)","v":"2010"},null,null,null,null,null,null,null,null," Microsoft Office 2010"]
[null," Microsoft Office 2013",{"$f":"RIGHT(B11,LEN(B11)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B11&\"0123456789\"))+1)","v":"2013"},null,null,null,null,null,null,null,null," Microsoft Office 2013"]
[null," Microsoft Office 2016",{"$f":"RIGHT(B12,LEN(B12)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B12&\"0123456789\"))+1)","v":"2016"},null,null,null,null,null,null,null,null," Microsoft Office 2016"]
[null," Microsoft Office 2019",{"$f":"RIGHT(B13,LEN(B13)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B13&\"0123456789\"))+1)","v":"2019"},null,null,null,null,null,null,null,null," Microsoft Office 2019"]

{"sheet":"Numbers Preceding Text","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Separating Numbers Preceding Text",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Version","Year",null,null,null,null,null,null,null,null,"Version","Year"]
[null,"95 Microsoft Office",{"$f":"LEFT(B5,SUM(LEN(B5)-LEN(SUBSTITUTE(B5,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"95"},null,null,null,null,null,null,null,null,"95 Microsoft Office"]
[null,"97 Microsoft Office ",{"$f":"LEFT(B6,SUM(LEN(B6)-LEN(SUBSTITUTE(B6,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"97"},null,null,null,null,null,null,null,null,"97 Microsoft Office "]
[null,"2000 Microsoft Office",{"$f":"LEFT(B7,SUM(LEN(B7)-LEN(SUBSTITUTE(B7,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2000"},null,null,null,null,null,null,null,null,"2000 Microsoft Office"]
[null,"2003 Microsoft Office",{"$f":"LEFT(B8,SUM(LEN(B8)-LEN(SUBSTITUTE(B8,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2003"},null,null,null,null,null,null,null,null,"2003 Microsoft Office"]
[null,"2007 Microsoft Office",{"$f":"LEFT(B9,SUM(LEN(B9)-LEN(SUBSTITUTE(B9,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2007"},null,null,null,null,null,null,null,null,"2007 Microsoft Office"]
[null,"2010 Microsoft Office",{"$f":"LEFT(B10,SUM(LEN(B10)-LEN(SUBSTITUTE(B10,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2010"},null,null,null,null,null,null,null,null,"2010 Microsoft Office"]
[null,"2013 Microsoft Office",{"$f":"LEFT(B11,SUM(LEN(B11)-LEN(SUBSTITUTE(B11,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2013"},null,null,null,null,null,null,null,null,"2013 Microsoft Office"]
[null,"2016 Microsoft Office",{"$f":"LEFT(B12,SUM(LEN(B12)-LEN(SUBSTITUTE(B12,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2016"},null,null,null,null,null,null,null,null,"2016 Microsoft Office"]
[null,"2016 Microsoft Office",{"$f":"LEFT(B13,SUM(LEN(B13)-LEN(SUBSTITUTE(B13,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"2016"},null,null,null,null,null,null,null,null,"2016 Microsoft Office"]

{"sheet":"Separate Decimal Numbers","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Separating Decimal Numbers ",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Version","Year",null,null,null,null,null,null,null,null,"Version","Year"]
[null," Microsoft Office 95.1",{"$f":"RIGHT(B5,LEN(B5)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))+1)","v":"95.1"},null,null,null,null,null,null,null,null," Microsoft Office 95.1"]
[null," Microsoft Office 97",{"$f":"RIGHT(B6,LEN(B6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))+1)","v":"97"},null,null,null,null,null,null,null,null," Microsoft Office 97"]
[null," Microsoft Office 2000",{"$f":"RIGHT(B7,LEN(B7)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))+1)","v":"2000"},null,null,null,null,null,null,null,null," Microsoft Office 2000"]
[null," Microsoft Office 2003",{"$f":"RIGHT(B8,LEN(B8)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))+1)","v":"2003"},null,null,null,null,null,null,null,null," Microsoft Office 2003"]
[null," Microsoft Office 2007.2",{"$f":"RIGHT(B9,LEN(B9)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B9&\"0123456789\"))+1)","v":"2007.2"},null,null,null,null,null,null,null,null," Microsoft Office 2007.2"]
[null," Microsoft Office 2010",{"$f":"RIGHT(B10,LEN(B10)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B10&\"0123456789\"))+1)","v":"2010"},null,null,null,null,null,null,null,null," Microsoft Office 2010"]
[null," Microsoft Office 2013",{"$f":"RIGHT(B11,LEN(B11)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B11&\"0123456789\"))+1)","v":"2013"},null,null,null,null,null,null,null,null," Microsoft Office 2013"]
[null," Microsoft Office 2016",{"$f":"RIGHT(B12,LEN(B12)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B12&\"0123456789\"))+1)","v":"2016"},null,null,null,null,null,null,null,null," Microsoft Office 2016"]
[null," Microsoft Office 2019.3",{"$f":"RIGHT(B13,LEN(B13)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},B13&\"0123456789\"))+1)","v":"2019.3"},null,null,null,null,null,null,null,null," Microsoft Office 2019.3"]

{"sheet":"Dataset-2","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Employee Names and ID"]
[]
[null,"ID and Names"]
[null,"1214 Jack Connor"]
[null,"1215 Charlie Kyle"]
[null,"1219 Thomas Joe"]
[null,"1778 George Reece"]
[null,"1889 William Damian"]
[null,"2434 Charles Theron"]
[null,"9525 Wilkin Greenwood"]
[null,"3264 Anne Josephine"]
[null,"4938 Carla Smith"]

{"sheet":"Using Flash Fill","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Flash Fill Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID and Names","ID",null,null,null,null,null,null,null,null,"ID and Names","ID"]
[null,"1214 Jack Connor",1214,null,null,null,null,null,null,null,null,"1214 Jack Connor"]
[null,"1215 Charlie Kyle",1215,null,null,null,null,null,null,null,null,"1215 Charlie Kyle"]
[null,"1219 Thomas Joe",1219,null,null,null,null,null,null,null,null,"1219 Thomas Joe"]
[null,"1778 George Reece",1778,null,null,null,null,null,null,null,null,"1778 George Reece"]
[null,"1889 William Damian",1889,null,null,null,null,null,null,null,null,"1889 William Damian"]
[null,"2434 Charles Theron",2434,null,null,null,null,null,null,null,null,"2434 Charles Theron"]
[null,"9525 Wilkin Greenwood",9525,null,null,null,null,null,null,null,null,"9525 Wilkin Greenwood"]
[null,"3264 Anne Josephine",3264,null,null,null,null,null,null,null,null,"3264 Anne Josephine"]
[null,"4938 Carla Smith",4938,null,null,null,null,null,null,null,null,"4938 Carla Smith"]

{"sheet":"Delimiter Option","index":6,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Delimiter Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID and Names","ID","First Name","Last Name",null,null,null,null,null,null,"ID and Names","ID","First Name","Last Name"]
[null,"1214 Jack Connor",1214,"Jack","Connor",null,null,null,null,null,null,"1214 Jack Connor"]
[null,"1215 Charlie Kyle",1215,"Charlie","Kyle",null,null,null,null,null,null,"1215 Charlie Kyle"]
[null,"1219 Thomas Joe",1219,"Thomas","Joe",null,null,null,null,null,null,"1219 Thomas Joe"]
[null,"1778 George Reece",1778,"George","Reece",null,null,null,null,null,null,"1778 George Reece"]
[null,"1889 William Damian",1889,"William","Damian",null,null,null,null,null,null,"1889 William Damian"]
[null,"2434 Charles Theron",2434,"Charles","Theron",null,null,null,null,null,null,"2434 Charles Theron"]
[null,"9525 Wilkin Greenwood",9525,"Wilkin","Greenwood",null,null,null,null,null,null,"9525 Wilkin Greenwood"]
[null,"3264 Anne Josephine",3264,"Anne","Josephine",null,null,null,null,null,null,"3264 Anne Josephine"]
[null,"4938 Carla Smith",4938,"Carla","Smith",null,null,null,null,null,null,"4938 Carla Smith"]

{"sheet":"Dataset-3","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Departments and Employee ID"]
[]
[null,"Department","Employee ID"]
[null,"Accounting","AA12"]
[null,"HR","AG28"]
[null,"HR","AZ36"]
[null,"Engineering","AT41"]
[null,"Accounting","AA10"]
[null,"Engineering","AZ36"]
[null,"Operations","AP84"]
[null,"Marketing","AZ37"]
[null,"Operations","AP83"]
[null,"Accounting","AG29"]

{"sheet":"Fixed Width Feature","index":8,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Fixed Width Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Department","Employee ID","Code","Number",null,null,null,null,null,null,"Department","Employee ID","Code","Number"]
[null,"Accounting","AA12","AA",12,null,null,null,null,null,null,"Accounting","AA12"]
[null,"HR","AG28","AG",28,null,null,null,null,null,null,"HR","AG28"]
[null,"HR","AZ36","AZ",36,null,null,null,null,null,null,"HR","AZ36"]
[null,"Engineering","AT41","AT",41,null,null,null,null,null,null,"Engineering","AT41"]
[null,"Accounting","AA10","AA",10,null,null,null,null,null,null,"Accounting","AA10"]
[null,"Engineering","AZ36","AZ",36,null,null,null,null,null,null,"Engineering","AZ36"]
[null,"Operations","AP84","AP",84,null,null,null,null,null,null,"Operations","AP84"]
[null,"Marketing","AZ37","AZ",37,null,null,null,null,null,null,"Marketing","AZ37"]
[null,"Operations","AP83","AP",83,null,null,null,null,null,null,"Operations","AP83"]
[null,"Accounting","AG29","AG",29,null,null,null,null,null,null,"Accounting","AG29"]

{"sheet":"Power Query","index":9,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query Editor"]
[]
[null,"Application","Year"]
[null," Microsoft Office ","95"]
[null," Microsoft Office ","97"]
[null," Microsoft Office ","2000"]
[null," Microsoft Office ","2003"]
[null," Microsoft Office ","2007"]
[null," Microsoft Office ","2010"]
[null," Microsoft Office ","2013"]
[null," Microsoft Office ","2016"]
[null," Microsoft Office ","2019"]

{"sheet":"VBA Code","index":10,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID and Names","ID",null,null,null,null,null,null,null,null,"ID and Names","ID"]
[null,"1214 Jack Connor",{"$f":"SplitNumAndText(B5,1)","v":"1214"},null,null,null,null,null,null,null,null,"1214 Jack Connor"]
[null,"1215 Charlie Kyle",{"$f":"SplitNumAndText(B6,1)","v":"1215"},null,null,null,null,null,null,null,null,"1215 Charlie Kyle"]
[null,"1219 Thomas Joe",{"$f":"SplitNumAndText(B7,1)","v":"1219"},null,null,null,null,null,null,null,null,"1219 Thomas Joe"]
[null,"1778 George Reece",{"$f":"SplitNumAndText(B8,1)","v":"1778"},null,null,null,null,null,null,null,null,"1778 George Reece"]
[null,"1889 William Damian",{"$f":"SplitNumAndText(B9,1)","v":"1889"},null,null,null,null,null,null,null,null,"1889 William Damian"]
[null,"2434 Charles Theron",{"$f":"SplitNumAndText(B10,1)","v":"2434"},null,null,null,null,null,null,null,null,"2434 Charles Theron"]
[null,"9525 Wilkin Greenwood",{"$f":"SplitNumAndText(B11,1)","v":"9525"},null,null,null,null,null,null,null,null,"9525 Wilkin Greenwood"]
[null,"3264 Anne Josephine",{"$f":"SplitNumAndText(B12,1)","v":"3264"},null,null,null,null,null,null,null,null,"3264 Anne Josephine"]
[null,"4938 Carla Smith",{"$f":"SplitNumAndText(B13,1)","v":"4938"},null,null,null,null,null,null,null,null,"4938 Carla Smith"]

{"sheet":"Splitting Numbers","index":11,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,3,3,6],[1,1,1,6],[1,11,1,16],[3,13,3,16]]}
[]
[null,"Using Formula to Split Numbers",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","ID","Splitted Employee ID",null,null,null,null,null,null,null,"Name","ID","Splitted Employee ID"]
[null,"Jack Connor",1214,{"$f":"MID($C5,COLUMN()-(COLUMN($D5)- 1),1)","v":"1"},{"$f":"MID($C5,COLUMN()-(COLUMN($D5)- 1),1)","v":"2"},"1","4",null,null,null,null,"Jack Connor",1214]
[null,"Charlie Kyle",1215,{"$f":"MID($C6,COLUMN()-(COLUMN($D6)- 1),1)","v":"1"},"2","1","5",null,null,null,null,"Charlie Kyle",1215]
[null,"Thomas Joe",1219,"1","2","1","9",null,null,null,null,"Thomas Joe",1219]
[null,"George Reece",1778,"1","7","7","8",null,null,null,null,"George Reece",1778]
[null,"William Damian",1889,"1","8","8","9",null,null,null,null,"William Damian",1889]
[null,"Charles Theron",2434,"2","4","3","4",null,null,null,null,"Charles Theron",2434]
[null,"Wilkin Greenwood",9525,"9","5","2","5",null,null,null,null,"Wilkin Greenwood",9525]
[null,"Anne Josephine",3264,"3","2","6","4",null,null,null,null,"Anne Josephine",3264]
[null,"Carla Smith",4938,"4","9","3","8",null,null,null,null,"Carla Smith",4938]

{"sheet":"Dataset-4","index":12,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Names and National ID"]
[]
[null,"Names","National ID"]
[null,"Charlie",144598]
[null,"Reece",567481]
[null,"Charlie",568878]
[null,"Damian",569972]
[null,"William",560098]
[null,"Oliver",789896]
[null,"Connor",121588]
[null,"Theron",139984]
[null,"Wilkin",998890]

{"sheet":"Split Number into 2 Columns","index":13,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Splitting Numbers into Two Columns",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Names","National ID","ID Number","Birth Year",null,null,null,null,null,null,"Names","National ID","ID Number","Birth Year"]
[null,"Charlie",144598,1445,98,null,null,null,null,null,null,"Charlie",144598]
[null,"Reece",567481,5674,81,null,null,null,null,null,null,"Reece",567481]
[null,"Charlie",568878,5688,78,null,null,null,null,null,null,"Charlie",568878]
[null,"Damian",569972,5699,72,null,null,null,null,null,null,"Damian",569972]
[null,"William",560098,5600,98,null,null,null,null,null,null,"William",560098]
[null,"Oliver",789896,7898,96,null,null,null,null,null,null,"Oliver",789896]
[null,"Connor",121588,1215,88,null,null,null,null,null,null,"Connor",121588]
[null,"Theron",139984,1399,84,null,null,null,null,null,null,"Theron",139984]
[null,"Wilkin",998890,9988,90,null,null,null,null,null,null,"Wilkin",998890]