{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dataset","REPLACE Function","RIGHT Function","RIGHT and LEN Functions","VALUE and RIGHT Functions","LEFT Function","LEFT and LEN Function","Using LEFT & SEARCH","SUBSTITUTE Function","MID and LEN Functions","Flash Fill","Find & Replace","Text to Columns","Remove First N Character","Remove Last N Char"],"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","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Product Information of ABC Company"]
[]
[null,"Product & ID","Order Date","Delivery Details"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"REPLACE Function","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,10,1,13],[1,1,1,4]]}
[]
[null,"Using REPLACE Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Adress",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Adress"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"REPLACE(D5, 1, 13, \"\")","v":"2101, Waverley "},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"REPLACE(D6, 1, 13, \"\")","v":"1835, Medina"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","4 , Miami",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","208 , LA",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","675, East Buena ",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","00, Deer ",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","01, Bahamas ",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","103 , Florida",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","6, Wayels Street",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"RIGHT Function","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying RIGHT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Order ID",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Order Id"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"RIGHT(B5,4)","v":"1001"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"RIGHT(B6,4)","v":"1002"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","1003",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","1004",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","1005",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","1006",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","1009",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","1008",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","1007",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"RIGHT and LEN Functions","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Employing RIGHT and LEN Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Order ID",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Order Id"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"RIGHT(B5, LEN(B5) - 6)","v":"1001"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"RIGHT(B6, LEN(B6) - 7)","v":"1002"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami",{"$f":"RIGHT(B7, LEN(B7) - 11)","v":"1003"},null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA",{"$f":"RIGHT(B8, LEN(B8) - 5)","v":"1004"},null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ",{"$f":"RIGHT(B9, LEN(B9) - 7)","v":"1005"},null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ",{"$f":"RIGHT(B10, LEN(B10) - 11)","v":"1006"},null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ",{"$f":"RIGHT(B11, LEN(B11) - 7)","v":"1009"},null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida",{"$f":"RIGHT(B12, LEN(B12) - 7)","v":"1008"},null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street",{"$f":"RIGHT(B13, LEN(B13) - 8)","v":"1007"},null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"VALUE and RIGHT Functions","index":4,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Incorporating VALUE and RIGHT Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Order ID",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Order Id"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"VALUE(RIGHT(B5, LEN(B5) - 6))","v":1001},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"VALUE(RIGHT(B6, LEN(B6) - 7))","v":1002},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami",{"$f":"VALUE(RIGHT(B7, LEN(B7) - 11))","v":1003},null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA",{"$f":"VALUE(RIGHT(B8, LEN(B8) - 5))","v":1004},null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ",{"$f":"RIGHT(B9, LEN(B9) - 7)","v":"1005"},null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ",{"$f":"RIGHT(B10, LEN(B10) - 11)","v":"1006"},null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ",{"$f":"RIGHT(B11, LEN(B11) - 7)","v":"1009"},null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida",{"$f":"RIGHT(B12, LEN(B12) - 7)","v":"1008"},null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street",{"$f":"RIGHT(B13, LEN(B13) - 8)","v":"1007"},null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"LEFT Function","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Utilizing LEFT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Product",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Product"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"LEFT(B5, 5)","v":"Apple"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"LEFT(B6, 6)","v":"Orange"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami",{"$f":"LEFT(B7, 10)","v":"Strawberry"},null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA",{"$f":"LEFT(B8, 4)","v":"Kiwi"},null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ",{"$f":"LEFT(B9, 6)","v":"Cherry"},null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ",{"$f":"LEFT(B10, 10)","v":"Blackberry"},null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ",{"$f":"LEFT(B11, 6)","v":"Cherry"},null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida",{"$f":"LEFT(B12, 6)","v":"Orange"},null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street",{"$f":"LEFT(B13, 7)","v":"Avacado"},null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"LEFT and LEN Function","index":6,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Engaging LEFT and LEN Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Product",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Product"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"LEFT(B5, LEN(B5) - 5)","v":"Apple"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"LEFT(B6, LEN(B6) - 5)","v":"Orange"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","Strawberry",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","Kiwi",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","Cherry",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","Blackberry",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","Cherry",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","Orange",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","Avacado",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Using LEFT & SEARCH","index":7,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying LEFT and SEARCH Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Status",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Status"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"LEFT(D5, SEARCH(\"_at_\", D5) -1)","v":"Delivered"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"LEFT(D6, SEARCH(\"_at_\", D6) -1)","v":"Delivered"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","Pending",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","Delivered",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","Delivered",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","Pending",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","Pending",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","Delivered",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","Pending",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"SUBSTITUTE Function","index":8,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Implementing SUBSTITUTE Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product ","Order Date","Delivery Details","Cleaned",null,null,null,null,null,"Product ","Order Date","Delivery Details","Cleaned"]
[null,"%Ap%ple%","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"SUBSTITUTE(B5,\"%\",\"\")","v":"Apple"},null,null,null,null,null,"%Ap%ple%","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Ora%nge","2021-12-16","Delivered_at_1835, Medina",{"$f":"SUBSTITUTE(B6,\"%\",\"\")","v":"Orange"},null,null,null,null,null,"Ora%nge","2021-12-16","Delivered_at_1835, Medina"]
[null,"Straw%b%erry","2021-12-17","Pending_at_104 , Miami","Strawberry",null,null,null,null,null,"Straw%b%erry","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi%","2021-12-18","Delivered_at_208 , LA","Kiwi",null,null,null,null,null,"Kiwi%","2021-12-18","Delivered_at_208 , LA"]
[null,"Ch%erry","2021-12-19","Delivered_at_675, East Buena ","Cherry",null,null,null,null,null,"Ch%erry","2021-12-19","Delivered_at_675, East Buena "]
[null,"Bla%ckber%ry","2021-12-20","Pending_at_3500, Deer ","Blackberry",null,null,null,null,null,"Bla%ckber%ry","2021-12-20","Pending_at_3500, Deer "]
[null,"%Cher%ry%","2021-12-21","Pending_at_3201, Bahamas ","Cherry",null,null,null,null,null,"%Cher%ry%","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange%","2021-12-22","Delivered_at_103 , Florida","Orange",null,null,null,null,null,"Orange%","2021-12-22","Delivered_at_103 , Florida"]
[null,"A%vacado","2021-12-23","Pending_at_456, Wayels Street","Avacado",null,null,null,null,null,"A%vacado","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"MID and LEN Functions","index":9,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Employing MID and LEN Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Order ID",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Order ID"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"MID(B5,7,LEN(B5)-5)","v":"1001"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Apple_1007","2021-12-16","Delivered_at_1835, Medina",{"$f":"MID(B6,7,LEN(B6)-5)","v":"1007"},null,null,null,null,null,"Apple_1007","2021-12-16","Delivered_at_1835, Medina"]
[null,"Apple_1006","2021-12-17","Pending_at_104 , Miami","1006",null,null,null,null,null,"Apple_1006","2021-12-17","Pending_at_104 , Miami"]
[null,"Apple_1005","2021-12-18","Delivered_at_208 , LA","1005",null,null,null,null,null,"Apple_1005","2021-12-18","Delivered_at_208 , LA"]
[null,"Apple_1009","2021-12-19","Delivered_at_675, East Buena ","1009",null,null,null,null,null,"Apple_1009","2021-12-19","Delivered_at_675, East Buena "]
[null,"Apple_1004","2021-12-20","Pending_at_3500, Deer ","1004",null,null,null,null,null,"Apple_1004","2021-12-20","Pending_at_3500, Deer "]
[null,"Apple_1002","2021-12-21","Pending_at_3201, Bahamas ","1002",null,null,null,null,null,"Apple_1002","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Apple_1008","2021-12-22","Delivered_at_103 , Florida","1008",null,null,null,null,null,"Apple_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Apple_1003","2021-12-23","Pending_at_456, Wayels Street","1003",null,null,null,null,null,"Apple_1003","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Flash Fill","index":10,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying Flash Fill Feature",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Status",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Status"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ","Delivered",null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina","Delivered",null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","Pending",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","Delivered",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","Delivered",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","Pending",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","Pending",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","Delivered",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","Pending",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Find & Replace","index":11,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,13]]}
[]
[null,"Enforcing Find and Replace Feature",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product ","Order Date","Delivery Details",null,null,null,null,null,null,"Product ","Order Date","Delivery Details"]
[null,"%Ap%ple%","2021-12-15","Delivered_at_2101, Waverley ",null,null,null,null,null,null,"%Ap%ple%","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Ora%nge","2021-12-16","Delivered_at_1835, Medina",null,null,null,null,null,null,"Ora%nge","2021-12-16","Delivered_at_1835, Medina"]
[null,"Straw%b%erry","2021-12-17","Pending_at_104 , Miami",null,null,null,null,null,null,"Straw%b%erry","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi%","2021-12-18","Delivered_at_208 , LA",null,null,null,null,null,null,"Kiwi%","2021-12-18","Delivered_at_208 , LA"]
[null,"Ch%erry","2021-12-19","Delivered_at_675, East Buena ",null,null,null,null,null,null,"Ch%erry","2021-12-19","Delivered_at_675, East Buena "]
[null,"Bla%ckber%ry","2021-12-20","Pending_at_3500, Deer ",null,null,null,null,null,null,"Bla%ckber%ry","2021-12-20","Pending_at_3500, Deer "]
[null,"%Cher%ry%","2021-12-21","Pending_at_3201, Bahamas ",null,null,null,null,null,null,"%Cher%ry%","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange%","2021-12-22","Delivered_at_103 , Florida",null,null,null,null,null,null,"Orange%","2021-12-22","Delivered_at_103 , Florida"]
[null,"A%vacado","2021-12-23","Pending_at_456, Wayels Street",null,null,null,null,null,null,"A%vacado","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Text to Columns","index":12,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,6],[1,10,1,13]]}
[]
[null,"Using Text to Columns Feature",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Status","Address",null,null,null,null,"Product & ID","Order Date","Delivery Details","Status"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ","Delivered","at","2101, Waverley ",null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina","Delivered","at","1835, Medina",null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","Pending","at","104 , Miami",null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","Delivered","at","208 , LA",null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","Delivered","at","675, East Buena ",null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","Pending","at","3500, Deer ",null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","Pending","at","3201, Bahamas ",null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","Delivered","at","103 , Florida",null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","Pending","at","456, Wayels Street",null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Remove First N Character","index":13,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Incorporating VBA to Remove First Characters",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Status",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Status"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"RemoveFirstx(B5,6)","v":"1001"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"RemoveFirstx(B6,7)","v":"1002"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami",{"$f":"RemoveFirstx(B7,6)","v":"erry_1003"},null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","004",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","_1005",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","erry_1006",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","_1009",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","_1008",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","o_1007",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]

{"sheet":"Remove Last N Char","index":14,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying VBA to Remove Last Characters",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product & ID","Order Date","Delivery Details","Order ID",null,null,null,null,null,"Product & ID","Order Date","Delivery Details","Order ID"]
[null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley ",{"$f":"RemoveLastx(B5,5)","v":"Apple"},null,null,null,null,null,"Apple_1001","2021-12-15","Delivered_at_2101, Waverley "]
[null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina",{"$f":"RemoveLastx(B6,5)","v":"Orange"},null,null,null,null,null,"Orange_1002","2021-12-16","Delivered_at_1835, Medina"]
[null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami","Strawberry",null,null,null,null,null,"Strawberry_1003","2021-12-17","Pending_at_104 , Miami"]
[null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA","Kiwi",null,null,null,null,null,"Kiwi_1004","2021-12-18","Delivered_at_208 , LA"]
[null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena ","Cherry",null,null,null,null,null,"Cherry_1005","2021-12-19","Delivered_at_675, East Buena "]
[null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer ","Blackberry",null,null,null,null,null,"Blackberry_1006","2021-12-20","Pending_at_3500, Deer "]
[null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas ","Cherry",null,null,null,null,null,"Cherry_1009","2021-12-21","Pending_at_3201, Bahamas "]
[null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida","Orange",null,null,null,null,null,"Orange_1008","2021-12-22","Delivered_at_103 , Florida"]
[null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street","Avacado",null,null,null,null,null,"Avacado_1007","2021-12-23","Pending_at_456, Wayels Street"]