{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Use Find & Replace Command","Perform SUBSTITUTE Function","TRUNC & SUBSTITUTE Function","SUMPRODUCT & SUBSTITUTE Functio","VBA Code"],"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":"Use Find & Replace Command","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use Find & Replace Command",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Product","Product Code","Total Sales",null,null,null,"Sl. No.","Product","Product Code","Total Sales"]
[null,1,"Orange","OE12",955,null,null,null,1,"Orange","OE*12",955]
[null,2,"Apple","AE 45",645,null,null,null,2,"Apple","*AE 45",645]
[null,3,"Watermelon","WN 94",715,null,null,null,3,"Watermelon","WN 94*",715]
[null,4,"Strawberry","SY23",690,null,null,null,4,"Strawberry","SY*23**",690]
[null,5,"Grape","GE 13",660,null,null,null,5,"Grape","**GE 13**",660]
[null,6,"Mango","MG94",930,null,null,null,6,"Mango","MG****94",930]
[null,7,"Banana","BN-56",585,null,null,null,7,"Banana","**BN-56**",585]
[null,8,"Papaya","PA61",720,null,null,null,8,"Papaya","**PA**61**",720]

{"sheet":"Perform SUBSTITUTE Function","index":1,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Perform SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Product","Product Code","Total Sales",null,"Result Removing Asterisk",null,null,null,null,null,"Sl. No.","Product","Product Code","Total Sales",null,"Result Removing Asterisk"]
[null,1,"Orange","OE*12",955,null,{"$f":"SUBSTITUTE(D5,\"*\",\"\")","v":"OE12"},null,null,null,null,null,1,"Orange","OE*12",955]
[null,2,"Apple","*AE 45",645,null,{"$f":"SUBSTITUTE(D6,\"*\",\"\")","v":"AE 45"},null,null,null,null,null,2,"Apple","*AE 45",645]
[null,3,"Watermelon","WN 94*",715,null,"WN 94",null,null,null,null,null,3,"Watermelon","WN 94*",715]
[null,4,"Strawberry","SY*23**",690,null,"SY23",null,null,null,null,null,4,"Strawberry","SY*23**",690]
[null,5,"Grape","**GE 13**",660,null,"GE 13",null,null,null,null,null,5,"Grape","**GE 13**",660]
[null,6,"Mango","MG****94",930,null,"MG94",null,null,null,null,null,6,"Mango","MG****94",930]
[null,7,"Banana","**BN-56**",585,null,"BN-56",null,null,null,null,null,7,"Banana","**BN-56**",585]
[null,8,"Papaya","**PA**61**",720,null,"PA61",null,null,null,null,null,8,"Papaya","**PA**61**",720]

{"sheet":"TRUNC & SUBSTITUTE Function","index":2,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,11,1,15],[1,1,1,5]]}
[]
[null,"Combine TRUNC & SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Employee Name","Employee ID",null,"Result Removing Asterisk",null,null,null,null,null,"Sl. No.","Employee Name","Employee ID",null,"Result Removing Asterisk"]
[null,1,"Henry","*1278",null,{"$f":"TRUNC(SUBSTITUTE(D5,\"*\",\"\"),0)","v":1278},null,null,null,null,null,1,"Henry","*1278"]
[null,2,"Thomas","45*15*",null,{"$f":"TRUNC(SUBSTITUTE(D6,\"*\",\"\"),0)","v":4515},null,null,null,null,null,2,"Thomas","45*15*"]
[null,3,"Ashley","*11*94*",null,1194,null,null,null,null,null,3,"Ashley","*11*94*"]
[null,4,"Henderson","8*23**",null,823,null,null,null,null,null,4,"Henderson","8*23**"]
[null,5,"James","13***45",null,1345,null,null,null,null,null,5,"James","13***45"]
[null,6,"Robert","17****94",null,1794,null,null,null,null,null,6,"Robert","17****94"]
[null,7,"Frank","**15*56**",null,1556,null,null,null,null,null,7,"Frank","**15*56**"]
[null,8,"Emily","**13**61**",null,1361,null,null,null,null,null,8,"Emily","**13**61**"]

{"sheet":"SUMPRODUCT & SUBSTITUTE Functio","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Utilize SUMPRODUCT & SUBSTITUTE Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Employee Name","Employee ID",null,"Result Removing Asterisk",null,null,null,null,"Sl. No.","Employee Name","Employee ID",null,"Result Removing Asterisk"]
[null,1,"Henry","*1278",null,{"$f":"SUMPRODUCT(SUBSTITUTE(0&D5,\"*\",\"\")+0)","v":1278},null,null,null,null,1,"Henry","*1278"]
[null,2,"Thomas","45*15*",null,{"$f":"SUMPRODUCT(SUBSTITUTE(0&D6,\"*\",\"\")+0)","v":4515},null,null,null,null,2,"Thomas","45*15*"]
[null,3,"Ashley","*11*94*",null,1194,null,null,null,null,3,"Ashley","*11*94*"]
[null,4,"Henderson","8*23**",null,823,null,null,null,null,4,"Henderson","8*23**"]
[null,5,"James","13***45",null,1345,null,null,null,null,5,"James","13***45"]
[null,6,"Robert","17****94",null,1794,null,null,null,null,6,"Robert","17****94"]
[null,7,"Frank","**15*56**",null,1556,null,null,null,null,7,"Frank","**15*56**"]
[null,8,"Emily","**13**61**",null,1361,null,null,null,null,8,"Emily","**13**61**"]

{"sheet":"VBA Code","index":4,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Run a VBA Code",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Product","Product Code","Total Sales",null,null,null,null,"Sl. No.","Product","Product Code","Total Sales"]
[null,1,"Orange","OE*12",955,null,null,null,null,1,"Orange","OE*12",955]
[null,2,"Apple","*AE 45",645,null,null,null,null,2,"Apple","*AE 45",645]
[null,3,"Watermelon","WN 94*",715,null,null,null,null,3,"Watermelon","WN 94*",715]
[null,4,"Strawberry","SY*23**",690,null,null,null,null,4,"Strawberry","SY*23**",690]
[null,5,"Grape","**GE 13**",660,null,null,null,null,5,"Grape","**GE 13**",660]
[null,6,"Mango","MG****94",930,null,null,null,null,6,"Mango","MG****94",930]
[null,7,"Banana","**BN-56**",585,null,null,null,null,7,"Banana","**BN-56**",585]
[null,8,"Papaya","**PA**61**",720,null,null,null,null,8,"Papaya","**PA**61**",720]