{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["TEXTJOIN","CONCAT","VBA","Ampersand","CONCATENATE AND TRANSPOSE","Separate Text","Split With Formula"],"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":"TEXTJOIN","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Applying TEXTJOIN Function",null,null,null,"Do Yourself"]
[]
[null,"Products",null,null,null,"Products"]
[null,"Laptop",null,null,null,"Laptop"]
[null,"Mobile",null,null,null,"Mobile"]
[null,"Charger",null,null,null,"Charger"]
[null,"Tablet",null,null,null,"Tablet"]
[null,"Keyboard",null,null,null,"Keyboard"]
[null,"Mouse",null,null,null,"Mouse"]
[]
[null,"Products",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:B10)","v":"Laptop,Mobile,Charger,Tablet,Keyboard,Mouse"},null,null,"Products"]

{"sheet":"CONCAT","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null," Using CONCAT Function",null,null,"Do Yourself"]
[]
[null,"Products","Delimiter",null,"Products","Delimiter"]
[null,"Laptop",",",null,"Laptop",","]
[null,"Mobile",",",null,"Mobile",","]
[null,"Charger",";",null,"Charger",";"]
[null,"Tablet",null,null,"Tablet"]
[]
[null,"Products",{"$f":"_xlfn.CONCAT(B5:C8)","v":"Laptop,Mobile,Charger;Tablet"},null,"Products"]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null," Applying VBA Code",null,null,null,"Do Yourself"]
[]
[null,"Products",null,null,null,"Products"]
[null,"Laptop",null,null,null,"Laptop"]
[null,"Mobile",null,null,null,"Mobile"]
[null,"Charger",null,null,null,"Charger"]
[null,"Tablet",null,null,null,"Tablet"]
[null,null,null,null,null,"Keyboard"]
[null,"Products","Laptop,Mobile,Charger,Tablet",null,null,"Mouse"]
[]
[null,null,null,null,null,"Products"]

{"sheet":"Ampersand","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Applying Ampersand Operator",null,null,"Do Yourself"]
[]
[null,"Products",null,null,"Products"]
[null,"Laptop",null,null,"Laptop"]
[null,"Mobile",null,null,"Mobile"]
[null,"Charger",null,null,"Charger"]
[null,"Tablet",null,null,"Tablet"]
[null,null,null,null,"Keyboard"]
[null,"Products",{"$f":"B5&\",\"&B6&\",\"&B7&\",\"&B8","v":"Laptop,Mobile,Charger,Tablet"},null,"Mouse"]
[]
[null,null,null,null,"Products"]

{"sheet":"CONCATENATE AND TRANSPOSE","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using a Combination of CONCATENATE and TRANSPOSE Functions",null,null,"Do Yourself"]
[]
[null,"Products",null,null,"Products"]
[null,"Laptop",null,null,"Laptop"]
[null,"Mobile",null,null,"Mobile"]
[null,"Charger",null,null,"Charger"]
[null,"Tablet",null,null,"Tablet"]
[null,"Keyboard",null,null,"Keyboard"]
[null,"Mouse",null,null,"Mouse"]
[]
[null,"Products",{"$f":"CONCATENATE(\"Laptop,\",\"Mobile,\",\"Charger,\",\"Tablet,\",\"Keyboard,\",\"Mouse,\")","v":"Laptop,Mobile,Charger,Tablet,Keyboard,Mouse,"},null,"Products"]

{"sheet":"Separate Text","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Separating Text",null,null,null,"Do Yourself"]
[]
[null,"Full Name","First Name","Last Name",null,"Full Name","First Name","Last Name"]
[null,"Adam,Smith","Adam","Smith",null,"Adam,Smith"]
[null,"Harry,Kane","Harry","Kane",null,"Harry,Kane"]
[null,"Jhon,Sina","Jhon","Sina",null,"Jhon,Sina"]
[null,"Jason,Todd","Jason","Todd",null,"Jason,Todd"]
[null,"Brad,Pitt","Brad","Pitt",null,"Brad,Pitt"]

{"sheet":"Split With Formula","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Splitting Text Uisng Formula",null,null,"Do Yourself"]
[]
[null,"Product Code","Number",null,"Product Code","Number"]
[null,"101-Apple",{"$f":"LEFT(B5,FIND(\"-\",B5)-1)","v":"101"},null,"101-Apple"]
[null,"102-Banana",{"$f":"LEFT(B6,FIND(\"-\",B6)-1)","v":"102"},null,"102-Banana"]
[null,"103-Orange","103",null,"103-Orange"]
[null,"104-Mango","104",null,"104-Mango"]
[null,"105-Guava","105",null,"105-Guava"]
[null,"106-Pineapple","106",null,"106-Pineapple"]