{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ampersand Operator","CONCATENATE Function","Flash Fill","before after Specific ","VBA to Add Specified Character "],"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":"Ampersand Operator","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Add Characters in Excel"]
[]
[null,"Guest List","Result"]
[null,"James",{"$f":"\"Professor \"&B5","v":"Professor James"}]
[null,"Robert",{"$f":"\"Professor \"&B6","v":"Professor Robert"}]
[null,"Christopher","Professor Christopher"]
[null,"Willium","Professor Willium"]
[null,"David","Professor David"]
[null,"Thomas","Professor Thomas"]
[null,"Daniel","Professor Daniel"]
[null,"Jacob","Professor Jacob"]

{"sheet":"CONCATENATE Function","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of the CONCATENATE Function"]
[]
[null,"Guest List","Result",null,"Guest List","Result"]
[null,"James",{"$f":"CONCATENATE(B5, \" (USA)\")","v":"James (USA)"},null,"James",{"$f":"CONCATENATE(\"Professor \",E5)","v":"Professor James"}]
[null,"Robert",{"$f":"CONCATENATE(B6, \" (USA)\")","v":"Robert (USA)"},null,"Robert",{"$f":"CONCATENATE(\"Professor \",E6)","v":"Professor Robert"}]
[null,"Christopher","Christopher (USA)",null,"Christopher","Professor Christopher"]
[null,"Willium","Willium (USA)",null,"Willium","Professor Willium"]
[null,"David","David (USA)",null,"David","Professor David"]
[null,"Thomas","Thomas (USA)",null,"Thomas","Professor Thomas"]
[null,"Daniel","Daniel (USA)",null,"Daniel","Professor Daniel"]
[null,"Jacob","Jacob (USA)",null,"Jacob","Professor Jacob"]

{"sheet":"Flash Fill","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Flash Fill Method"]
[]
[null,"Guest List","Result",null,"Guest List","Result"]
[null,"James","James (USA)",null,"James","Professor James"]
[null,"Robert","Robert (USA)",null,"Robert","Professor Robert"]
[null,"Christopher","Christopher (USA)",null,"Christopher","Professor Christopher"]
[null,"Willium","Willium (USA)",null,"Willium","Professor Willium"]
[null,"David","David (USA)",null,"David","Professor David"]
[null,"Thomas","Thomas (USA)",null,"Thomas","Professor Thomas"]
[null,"Daniel","Daniel (USA)",null,"Daniel","Professor Daniel"]
[null,"Jacob","Jacob (USA)",null,"Jacob","Professor Jacob"]

{"sheet":"before after Specific ","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Addition of Text Method"]
[]
[null,"Guest List","Result"]
[null,"James(USA)",{"$f":"CONCATENATE(LEFT(B5, 5), \"-\", RIGHT(B5, LEN(B5) -5))","v":"James-(USA)"}]
[null,"Robert(USA)",{"$f":"CONCATENATE(LEFT(B6, 6), \"-\", RIGHT(B6, LEN(B6) -6))","v":"Robert-(USA)"}]
[null,"Christopher(USA)",{"$f":"CONCATENATE(LEFT(B7, 11), \"-\", RIGHT(B7, LEN(B7) -11))","v":"Christopher-(USA)"}]
[null,"Willium(USA)",{"$f":"CONCATENATE(LEFT(B8, 7), \"-\", RIGHT(B8, LEN(B8) -7))","v":"Willium-(USA)"}]
[null,"David(USA)",{"$f":"CONCATENATE(LEFT(B9, 5), \"-\", RIGHT(B9, LEN(B9) -5))","v":"David-(USA)"}]
[null,"Thomas(USA)",{"$f":"CONCATENATE(LEFT(B10, 6), \"-\", RIGHT(B10, LEN(B10) -6))","v":"Thomas-(USA)"}]
[null,"Daniel(USA)","Danie-l(USA)"]
[null,"Jacob(USA)","Jacob-(USA)"]

{"sheet":"VBA to Add Specified Character ","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Running a VBA Code"]
[]
[null,"Guest List","Result",null,"Guest List","Result"]
[null,"James","James(USA)",null,"James","Professor James"]
[null,"Robert","Robert(USA)",null,"Robert","Professor Robert"]
[null,"Christopher","Christopher(USA)",null,"Christopher","Professor Christopher"]
[null,"Willium","Willium(USA)",null,"Willium","Professor Willium"]
[null,"David","David(USA)",null,"David","Professor David"]
[null,"Thomas","Thomas(USA)",null,"Thomas","Professor Thomas"]
[null,"Daniel","Daniel(USA)",null,"Daniel","Professor Daniel"]
[null,"Jacob","Jacob(USA)",null,"Jacob","Professor Jacob"]