{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","String Concatenate","Integer Concatenate","String Integer Concatenate","String Concatenate Selected","String Integer Selected","Concatenate Column","Concatenate String & Variable"],"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":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employee Information"]
[]
[null,"First Name","Last Name","Country Code","Area Code"]
[null,"John","Mathew",1,907]
[null,"Steve","Harris",1,209]
[null,"Paul","Abraham",1,530]
[null,"Ryan","Ings",1,831]
[null,"Mathew","Christ",1,239]
[null,"Victor","Moses",1,404]

{"sheet":"String Concatenate","index":1,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Concatenating Strings",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"First Name","Last Name","Full Name","Country Code","Area Code",null,null,null,null,null,"First Name","Last Name","Full Name","Country Code","Area Code"]
[null,"John","Mathew","John Mathew",1,907,null,null,null,null,null,"John","Mathew",null,1,907]
[null,"Steve","Harris","Steve Harris",1,209,null,null,null,null,null,"Steve","Harris",null,1,209]
[null,"Paul","Abraham","Paul Abraham",1,530,null,null,null,null,null,"Paul","Abraham",null,1,530]
[null,"Ryan","Ings","Ryan Ings",1,831,null,null,null,null,null,"Ryan","Ings",null,1,831]
[null,"Mathew","Christ","Mathew Christ",1,239,null,null,null,null,null,"Mathew","Christ",null,1,239]
[null,"Victor","Moses","Victor Moses",1,404,null,null,null,null,null,"Victor","Moses",null,1,404]

{"sheet":"Integer Concatenate","index":2,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Concatenating Integers",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"First Name","Last Name","Full Name","Country Code","Area Code","Dialing Code",null,null,null,null,"First Name","Last Name","Full Name","Country Code","Area Code","Dialing Code"]
[null,"John","Mathew","John Mathew",1,907,1907,null,null,null,null,"John","Mathew","John Mathew",1,907]
[null,"Steve","Harris","Steve Harris",1,209,1209,null,null,null,null,"Steve","Harris","Steve Harris",1,209]
[null,"Paul","Abraham","Paul Abraham",1,530,1530,null,null,null,null,"Paul","Abraham","Paul Abraham",1,530]
[null,"Ryan","Ings","Ryan Ings",1,831,1831,null,null,null,null,"Ryan","Ings","Ryan Ings",1,831]
[null,"Mathew","Christ","Mathew Christ",1,239,1239,null,null,null,null,"Mathew","Christ","Mathew Christ",1,239]
[null,"Victor","Moses","Victor Moses",1,404,1404,null,null,null,null,"Victor","Moses","Victor Moses",1,404]

{"sheet":"String Integer Concatenate","index":3,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Concatenating String And Integer",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"First Name","Last Name","Full Name","Country Code","Area Code","Info",null,null,null,null,"First Name","Last Name","Full Name","Country Code","Area Code","Info"]
[null,"John","Mathew","John Mathew",1,907,"John Mathew 907",null,null,null,null,"John","Mathew","John Mathew",1,907]
[null,"Steve","Harris","Steve Harris",1,209,null,null,null,null,null,"Steve","Harris","Steve Harris",1,209]
[null,"Paul","Abraham","Paul Abraham",1,530,null,null,null,null,null,"Paul","Abraham","Paul Abraham",1,530]
[null,"Ryan","Ings","Ryan Ings",1,831,null,null,null,null,null,"Ryan","Ings","Ryan Ings",1,831]
[null,"Mathew","Christ","Mathew Christ",1,239,null,null,null,null,null,"Mathew","Christ","Mathew Christ",1,239]
[null,"Victor","Moses","Victor Moses",1,404,null,null,null,null,null,"Victor","Moses","Victor Moses",1,404]

{"sheet":"String Concatenate Selected","index":4,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Concatenating Selected String",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"First Name","Last Name","Full Name","Country Code","Area Code",null,null,null,null,null,"First Name","Last Name","Full Name","Country Code","Area Code"]
[null,"John","Mathew",{"$f":"B5&\" \"&C5","v":"John Mathew"},1,907,null,null,null,null,null,"John","Mathew",null,1,907]
[null,"Steve","Harris",null,1,209,null,null,null,null,null,"Steve","Harris",null,1,209]
[null,"Paul","Abraham",null,1,530,null,null,null,null,null,"Paul","Abraham",null,1,530]
[null,"Ryan","Ings",null,1,831,null,null,null,null,null,"Ryan","Ings",null,1,831]
[null,"Mathew","Christ",null,1,239,null,null,{"$f":"G9&\" \"&H9","v":" "},null,null,"Mathew","Christ",null,1,239]
[null,"Victor","Moses",null,1,404,null,null,null,null,null,"Victor","Moses",null,1,404]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"B16&\" \"&C16","v":" "}]

{"sheet":"String Integer Selected","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Concatenating Selected Integer",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"First Name","Last Name","Full Name","Area Code","Info",null,null,null,null,null,"First Name","Last Name","Full Name","Area Code","Info"]
[null,"John","Mathew",{"$f":"B5&\" \"&C5","v":"John Mathew"},907,{"$f":"D5&\" \"&E5","v":"John Mathew 907"},null,null,null,null,null,"John","Mathew",{"$f":"L5&\" \"&M5","v":"John Mathew"},907]
[null,"Steve","Harris","Steve Harris",209,null,null,null,null,null,null,"Steve","Harris","Steve Harris",209]
[null,"Paul","Abraham","Paul Abraham",530,null,null,null,null,null,null,"Paul","Abraham","Paul Abraham",530]
[null,"Ryan","Ings","Ryan Ings",831,null,null,null,null,null,null,"Ryan","Ings","Ryan Ings",831]
[null,"Mathew","Christ","Mathew Christ",239,null,null,null,null,null,null,"Mathew","Christ","Mathew Christ",239]
[null,"Victor","Moses","Victor Moses",404,null,null,null,null,null,null,"Victor","Moses","Victor Moses",404]

{"sheet":"Concatenate Column","index":6,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Concatenating Entire Column",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name"," Author","Book Name and Author",null,null,null,null,null,null,null,"Book Name"," Author","Book Name and Author"]
[null,"Poor Economics"," Abhijit Banarjee","Poor Economics - Abhijit Banarjee",null,null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee"]
[null,"House of Wisdom"," Jim Khalili","House of Wisdom - Jim Khalili",null,null,null,null,null,null,null,"House of Wisdom"," Jim Khalili"]
[null,"Purple Cow"," Seth Godin","Purple Cow - Seth Godin",null,null,null,null,null,null,null,"Purple Cow"," Seth Godin"]
[null,"Made to Stick"," Chip Heath","Made to Stick - Chip Heath",null,null,null,null,null,null,null,"Made to Stick"," Chip Heath"]
[null,"The Black Swan"," Nassim Taleb","The Black Swan - Nassim Taleb",null,null,null,null,null,null,null,"The Black Swan"," Nassim Taleb"]
[null,"Thinking Fast and Slow"," Daniel Kahneman","Thinking Fast and Slow - Daniel Kahneman",null,null,null,null,null,null,null,"Thinking Fast and Slow"," Daniel Kahneman"]

{"sheet":"Concatenate String & Variable","index":7,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Concatenating String and Variable",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name"," Author","Price","Combined",null,null,null,null,null,null,"Book Name"," Author","Price","Combined"]
[null,"Poor Economics"," Abhijit Banarjee",22,"Poor Economics,  Abhijit Banarjee, 22",null,null,null,null,null,null,"Poor Economics"," Abhijit Banarjee",22,"Poor Economics,  Abhijit Banarjee, 22"]
[null,"House of Wisdom"," Jim Khalili",30,"House of Wisdom,  Jim Khalili, 30",null,null,null,null,null,null,"House of Wisdom"," Jim Khalili",30,"House of Wisdom,  Jim Khalili, 30"]
[null,"Purple Cow"," Seth Godin",25,"Purple Cow,  Seth Godin, 25",null,null,null,null,null,null,"Purple Cow"," Seth Godin",25,"Purple Cow,  Seth Godin, 25"]
[null,"Made to Stick"," Chip Heath",20,"Made to Stick,  Chip Heath, 20",null,null,null,null,null,null,"Made to Stick"," Chip Heath",20,"Made to Stick,  Chip Heath, 20"]
[null,"The Black Swan"," Nassim Taleb",18,"The Black Swan,  Nassim Taleb, 18",null,null,null,null,null,null,"The Black Swan"," Nassim Taleb",18,"The Black Swan,  Nassim Taleb, 18"]
[null,"Sapiens"," Daniel Kahneman",25,"Sapiens,  Daniel Kahneman, 25",null,null,null,null,null,null,"Sapiens"," Daniel Kahneman",25,"Sapiens,  Daniel Kahneman, 25"]