{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Concat Operator without space","Concat Operator with space","Concat Operator end of string","Concat Operator nth char","Concat Operator combine cells","Concat Function without space","Concat Function with space","Concat Function end of string","Concat Function nth char","Concat Function combine cells","TEXTJOIN","SEARCH","REPLACE","VBA Ending","VBA Beginning"],"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":"Concat Operator without space","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Concatenation Operator "]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"B5&C5","v":"Mobile PhoneMP"}]
[null,"Laptop","LT"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Operator with space","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Concatenation Operator "]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"B5&\" \" &C5","v":"Mobile Phone MP"}]
[null,"Laptop","LL"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Operator end of string","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Concatenation Operator "]
[]
[null,"Product","Code","Country Code"]
[null,"Mobile Phone","MP",{"$f":"C5& \"-US\"","v":"MP-US"}]
[null,"Laptop","LL"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Operator nth char","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Concatenation Operator "]
[]
[null,"Product","Code","Country Code","Added Text"]
[null,"Mobile Phone","MP",{"$f":"C5&\"US\"","v":"MPUS"},{"$f":"LEFT(D5,2)&\"-\"&RIGHT(D5,LEN(D5)-2)","v":"MP-US"}]
[null,"Laptop","LL",{"$f":"C6&\"US\"","v":"LLUS"}]
[null,"Mobile Charger","MC","MCUS"]
[null,"Smart Watch","SW","SWUS"]
[null,"Smart TV","ST","STUS"]
[null,"Laptop Charger","LC","LCUS"]

{"sheet":"Concat Operator combine cells","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Concatenation Operator "]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"C5&B5","v":"MPMobile Phone"}]
[null,"Laptop","LL"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Function without space","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Mobile PhoneMP"}]
[null,"Laptop","LT"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Function with space","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"Mobile Phone MP"}]
[null,"Laptop","LT"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Function end of string","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"Product","Code","Country Code"]
[null,"Mobile Phone","MP",{"$f":"_xlfn.CONCAT(C5,\"-US\")","v":"MP-US"}]
[null,"Laptop","LL"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"Concat Function nth char","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"Product","Code","Country Code","Added Text"]
[null,"Mobile Phone","MP",{"$f":"C5&\"US\"","v":"MPUS"},{"$f":"_xlfn.CONCAT(LEFT(D5,2),\"-\",RIGHT(D5,LEN(D5)-2))","v":"MP-US"}]
[null,"Laptop","LL",{"$f":"C6&\"US\"","v":"LLUS"}]
[null,"Mobile Charger","MC","MCUS"]
[null,"Smart Watch","SW","SWUS"]
[null,"Smart TV","ST","STUS"]
[null,"Laptop Charger","LC","LCUS"]

{"sheet":"Concat Function combine cells","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"Product","Code","Product Code"]
[null,"Mobile Phone","MP",{"$f":"_xlfn.CONCAT(C5,B5)","v":"MPMobile Phone"}]
[null,"Laptop","LL"]
[null,"Mobile Charger","MC"]
[null,"Smart Watch","SW"]
[null,"Smart TV","ST"]
[null,"Laptop Charger","LC"]

{"sheet":"TEXTJOIN","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying TEXTJOIN Function"]
[]
[null,"Product","Code","Country","Added Text"]
[null,"Mobile Phone","MP","US",{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,B5,C5,D5)","v":"Mobile Phone-MP-US"}]
[null,"Laptop","LL","US"]
[null,"Mobile Charger","MC","US"]
[null,"Smart Watch","SW","US"]
[null,"Smart TV","ST","US"]
[null,"Laptop Charger","LC","US"]

{"sheet":"SEARCH","index":11,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Implying SEARCH Function"]
[]
[null,"Product","Code","Country Code","Added Text"]
[null,"Mobile Phone","MP(D)",{"$f":"C5&\"US\"","v":"MP(D)US"},{"$f":"_xlfn.CONCAT(LEFT(D5,SEARCH(\")\",D5)),\"-\",RIGHT(D5,LEN(D5)-SEARCH(\")\",D5)))","v":"MP(D)-US"}]
[null,"Laptop","LT(ND)",{"$f":"C6&\"US\"","v":"LT(ND)US"}]
[null,"Mobile Charger","MC(D)","MC(D)US"]
[null,"Smart Watch","SW(D)","SW(D)US"]
[null,"Smart TV","ST(ND)","ST(ND)US"]
[null,"Laptop Charger","LC(D)","LC(D)US"]

{"sheet":"REPLACE","index":12,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing REPLACE Function "]
[]
[null,"Product","Code","Country Code","Added Text"]
[null,"Mobile Phone","MP",{"$f":"C5&\"US\"","v":"MPUS"},{"$f":"REPLACE(D5,2+1,0,\"-\")","v":"MP-US"}]
[null,"Laptop","LL",{"$f":"C6&\"US\"","v":"LLUS"}]
[null,"Mobile Charger","MC","MCUS"]
[null,"Smart Watch","SW","SWUS"]
[null,"Smart TV","ST","STUS"]
[null,"Laptop Charger","LC","LCUS"]

{"sheet":"VBA Ending","index":13,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code "]
[]
[null,"Product","Code","Country Code"]
[null,"Mobile Phone","MP","MP-US"]
[null,"Laptop","LL","LL-US"]
[null,"Mobile Charger","MC","MC-US"]
[null,"Smart Watch","SW","SW-US"]
[null,"Smart TV","ST","ST-US"]
[null,"Laptop Charger","LC","LC-US"]

{"sheet":"VBA Beginning","index":14,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code "]
[]
[null,"Product","Code","Country Code"]
[null,"Mobile Phone","MP","US-MP"]
[null,"Laptop","LL","US-LL"]
[null,"Mobile Charger","MC","US-MC"]
[null,"Smart Watch","SW","US-SW"]
[null,"Smart TV","ST","US-ST"]
[null,"Laptop Charger","LC","US-LC"]