{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["LSI","VBA","4","3","2","1","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"LSI","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Adding Comma","Country"]
[null,"Leonel Messi",{"$f":"B6&\",\"","v":"Leonel Messi,"},"Argentina"]
[null,"Henrique Casemiro",{"$f":"B7&\",\"","v":"Henrique Casemiro,"},"Brazil"]
[null,"Cristiano Ronaldo","Cristiano Ronaldo,","Portugal"]
[null,"Neymar Jr","Neymar Jr,","Brazil"]
[null,"Leroy Sane","Leroy Sane,","Germany"]

{"sheet":"VBA","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Adding Comma","Country"]
[null,"Leonel Messi","Leonel, Messi","Argentina"]
[null,"Henrique Casemiro","Henrique, Casemiro","Brazil"]
[null,"Cristiano Ronaldo","Cristiano, Ronaldo","Portugal"]
[null,"Neymar Jr","Neymar, Jr","Brazil"]
[null,"Leroy Sane","Leroy, Sane","Germany"]

{"sheet":"4","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Footballers List"]
[]
[null,"First Name ","Last Name","Player Name","Country"]
[null,"Leonel "," Messi",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:C6)","v":"Leonel , Messi"},"Argentina"]
[null,"Henrique","Casemiro",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B7:C7)","v":"Henrique,Casemiro"},"Brazil"]
[null,"Cristiano "," Ronaldo","Cristiano , Ronaldo","Portugal"]
[null,"Neymar "," Jr","Neymar , Jr","Brazil"]
[null,"Leroy "," Sane","Leroy , Sane","Germany"]

{"sheet":"3","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Country","Adding Comma"]
[null,"Leonel Messi","Argentina",{"$f":"B6&\",\"&C6","v":"Leonel Messi,Argentina"}]
[null,"Henrique Casemiro","Brazil",{"$f":"B7&\",\"&C7","v":"Henrique Casemiro,Brazil"}]
[null,"Cristiano Ronaldo","Portugal","Cristiano Ronaldo,Portugal"]
[null,"Neymar Jr","Brazil","Neymar Jr,Brazil"]
[null,"Leroy Sane","Germany","Leroy Sane,Germany"]

{"sheet":"2","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Adding Comma","Country"]
[null,"Leonel Messi",{"$f":"SUBSTITUTE(TRIM(B6),\" \",\", \")","v":"Leonel, Messi"},"Argentina"]
[null,"Henrique Casemiro",{"$f":"SUBSTITUTE(TRIM(B7),\" \",\", \")","v":"Henrique, Casemiro"},"Brazil"]
[null,"Cristiano Ronaldo","Cristiano, Ronaldo","Portugal"]
[null,"Neymar Jr","Neymar, Jr","Brazil"]
[null,"Leroy Sane","Leroy, Sane","Germany"]

{"sheet":"1","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Adding Comma","Country"]
[null,"Leonel Messi","Leonel, Messi","Argentina"]
[null,"Henrique Casemiro","Henrique, Casemiro","Brazil"]
[null,"Cristiano Ronaldo","Cristiano, Ronaldo","Portugal"]
[null,"Neymar Jr","Neymar, Jr","Brazil"]
[null,"Leroy Sane","Leroy, Sane","Germany"]

{"sheet":"Data","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Footballers List"]
[]
[null,"Player Name","Country"]
[null,"Leonel Messi","Argentina"]
[null,"Henrique Casemiro","Brazil"]
[null,"Cristiano Ronaldo","Portugal"]
[null,"Neymar Jr","Brazil"]
[null,"Leroy Sane","Germany"]
[]
[null,"Method","Outcome","Formula"]
[null,"Find & Replace Option","Leonel, Messi"]
[null,"SUBSTITUTE Function","Leonel, Messi","=SUBSTITUTE(TRIM(B6),\" \",\", \")"]
[null,"TEXTJOIN Function","Leonel, Messi","=B6&\",\"&C6"]
[null,"Ampersand Operator","Leonel, Messi","=TEXTJOIN(\",\",TRUE,B6:C6)"]
[null,"VBA","Leonel, Messi"]