{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main Dataset","Replace, VALUE & LEN","Left","Mid","Flash Fill","Remove first and last character","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":"Main Dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Student's of 'X' University"]
[]
[null,"Student Id","Name","Course No","Email Id"]
[null,20151,"James","ME 101",{"$f":"LOWER(_xlfn.CONCAT(\"**\",C5,\"@gmail.com**\"))","v":"**james@gmail.com**"}]
[null,20131,"Steves","CSE 201",{"$f":"LOWER(_xlfn.CONCAT(\"**\",C6,\"@gmail.com**\"))","v":"**steves@gmail.com**"}]
[null,20154,"John ","EEE 403","**john @gmail.com**"]
[null,20162,"Robert","ME 401","**robert@gmail.com**"]
[null,20128,"Michael","ME 203","**michael@gmail.com**"]
[null,20165,"William","CSE 301","**william@gmail.com**"]

{"sheet":"Replace, VALUE & LEN","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Combined Functions",null,null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Course No","Year",null,null,null,"Student Id","Name","Course No","Year"]
[null,20151,"James","ME 101",{"$f":"VALUE(REPLACE(B5,LEN(B5),1,\"\"))","v":2015},null,null,null,20151,"James","ME 101"]
[null,20131,"Steves","CSE 201",2013,null,null,null,20131,"Steves","CSE 201"]
[null,20154,"John ","EEE 403",2015,null,null,null,20154,"John ","EEE 403"]
[null,20162,"Robert","ME 401",2016,null,null,null,20162,"Robert","ME 401"]
[null,20128,"Michael","ME 203",2012,null,null,null,20128,"Michael","ME 203"]
[null,20165,"William","CSE 301",2016,null,null,null,20165,"William","CSE 301"]

{"sheet":"Left","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Employing LEFT Function",null,null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Course No","Department",null,null,null,"Student Id","Name","Course No","Department"]
[null,20151,"James","ME 101",{"$f":"LEFT(D5,LEN(D5)-3)","v":"ME "},null,null,null,20151,"James","ME 101"]
[null,20131,"Steves","CSE 201",{"$f":"LEFT(D6,LEN(D6)-3)","v":"CSE "},null,null,null,20131,"Steves","CSE 201"]
[null,20154,"John ","EEE 403","EEE ",null,null,null,20154,"John ","EEE 403"]
[null,20162,"Robert","ME 401","ME ",null,null,null,20162,"Robert","ME 401"]
[null,20128,"Michael","ME 203","ME ",null,null,null,20128,"Michael","ME 203"]
[null,20165,"William","CSE 301","CSE ",null,null,null,20165,"William","CSE 301"]

{"sheet":"Mid","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using MID Function",null,null,null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Course No","Department",null,null,null,null,"Student Id","Name","Course No","Department"]
[null,20151,"James","ME 101",{"$f":"MID(D5,1,LEN(D5)-3)","v":"ME "},null,null,null,null,20151,"James","ME 101"]
[null,20131,"Steves","CSE 201",{"$f":"MID(D6,1,LEN(D6)-3)","v":"CSE "},null,null,null,null,20131,"Steves","CSE 201"]
[null,20154,"John ","EEE 403","EEE ",null,null,null,null,20154,"John ","EEE 403"]
[null,20162,"Robert","ME 401","ME ",null,null,null,null,20162,"Robert","ME 401"]
[null,20128,"Michael","ME 203","ME ",null,null,null,null,20128,"Michael","ME 203"]
[null,20165,"William","CSE 301","CSE ",null,null,null,null,20165,"William","CSE 301"]

{"sheet":"Flash Fill","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying Flash Fill Feature",null,null,null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Course No","Department",null,null,null,null,"Student Id","Name","Course No","Department"]
[null,20151,"James","ME 101","ME",null,null,null,null,20151,"James","ME 101"]
[null,20131,"Steves","CSE 201","CSE",null,null,null,null,20131,"Steves","CSE 201"]
[null,20154,"John ","EEE 403","EEE",null,null,null,null,20154,"John ","EEE 403"]
[null,20162,"Robert","ME 401","ME",null,null,null,null,20162,"Robert","ME 401"]
[null,20128,"Michael","ME 203","ME",null,null,null,null,20128,"Michael","ME 203"]
[null,20165,"William","CSE 301","CSE",null,null,null,null,20165,"William","CSE 301"]

{"sheet":"Remove first and last character","index":5,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Combining MID & LEN Functions",null,null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Email Id","Real Email Id",null,null,null,"Student Id","Name","Email Id","Real Email Id"]
[null,20151,"James","**james@gmail.com**",{"$f":"MID(D5,3,LEN(D5)-4)","v":"james@gmail.com"},null,null,null,20151,"James","**james@gmail.com**"]
[null,20131,"Steves","**steves@gmail.com**",{"$f":"MID(D6,3,LEN(D6)-4)","v":"steves@gmail.com"},null,null,null,20131,"Steves","**steves@gmail.com**"]
[null,20154,"John ","**john @gmail.com**","john @gmail.com",null,null,null,20154,"John ","**john @gmail.com**"]
[null,20162,"Robert","**robert@gmail.com**","robert@gmail.com",null,null,null,20162,"Robert","**robert@gmail.com**"]
[null,20128,"Michael","**michael@gmail.com**","michael@gmail.com",null,null,null,20128,"Michael","**michael@gmail.com**"]
[null,20165,"William","**william@gmail.com**","william@gmail.com",null,null,null,20165,"William","**william@gmail.com**"]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Using VBA Code",null,null,null,null,null,"***Practice***"]
[]
[null,"Student Id","Name","Course No","Department",null,null,"Student Id","Name","Course No","Department"]
[null,20151,"James","ME 101",{"$f":"Remove_Lst_Ch(D5,3)","v":"ME "},null,null,20151,"James","ME 101"]
[null,20131,"Steves","CSE 201",{"$f":"Remove_Lst_Ch(D6,3)","v":"CSE "},null,null,20131,"Steves","CSE 201"]
[null,20154,"John ","EEE 403",{"$f":"Remove_Lst_Ch(D7,3)","v":"EEE "},null,null,20154,"John ","EEE 403"]
[null,20162,"Robert","ME 401",{"$f":"Remove_Lst_Ch(D8,3)","v":"ME "},null,null,20162,"Robert","ME 401"]
[null,20128,"Michael","ME 203",{"$f":"Remove_Lst_Ch(D9,3)","v":"ME "},null,null,20128,"Michael","ME 203"]
[null,20165,"William","CSE 301",{"$f":"Remove_Lst_Ch(D10,3)","v":"CSE "},null,null,20165,"William","CSE 301"]