{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ampersand Operator","VBA Code","CONCATENATE Function","Flash Fill Command","Sample Data Set"],"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":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Ampersand Operator"]
[]
[null,"Sales Person","Units","Unit Price","Total Sales","Add Text"]
[null,"John",500,25,{"$f":"C5*D5","v":12500},{"$f":"\"Total Sales of \" & B5 & \" is: \" &E5","v":"Total Sales of John is: 12500"}]
[null,"Morgan",455,31,{"$f":"C6*D6","v":14105},{"$f":"\"Total Sales of \" & B6 & \" is: \" &E6","v":"Total Sales of Morgan is: 14105"}]
[null,"Anderson",345,23,7935,"Total Sales of Anderson is: 7935"]
[null,"Robert",879,30,26370,"Total Sales of Robert is: 26370"]
[null,"Jim",290,40,11600,"Total Sales of Jim is: 11600"]
[null,"Jill",580,37,21460,"Total Sales of Jill is: 21460"]
[null,"David",650,29,18850,"Total Sales of David is: 18850"]

{"sheet":"VBA Code","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Sales Person","Units","Unit Price","Total Sales","Add Text"]
[null,"John",500,25,{"$f":"C5*D5","v":12500},"Total Sales of John is: 12500"]
[null,"Morgan",455,31,{"$f":"C6*D6","v":14105},"Total Sales of Morgan is: 14105"]
[null,"Anderson",345,23,7935,"Total Sales of Anderson is: 7935"]
[null,"Robert",879,30,26370,"Total Sales of Robert is: 26370"]
[null,"Jim",290,40,11600,"Total Sales of Jim is: 11600"]
[null,"Jill",580,37,21460,"Total Sales of Jill is: 21460"]
[null,"David",650,29,18850,"Total Sales of David is: 18850"]

{"sheet":"CONCATENATE Function","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing  CONCATENATE Function"]
[]
[null,"Sales Person","Units","Unit Price","Total Sales","Add Text"]
[null,"John",500,25,{"$f":"C5*D5","v":12500},{"$f":"CONCATENATE(\"Total Sales are: \",E5)","v":"Total Sales are: 12500"}]
[null,"Morgan",455,31,{"$f":"C6*D6","v":14105},{"$f":"CONCATENATE(\"Total Sales are: \",E6)","v":"Total Sales are: 14105"}]
[null,"Anderson",345,23,7935,"Total Sales are: 7935"]
[null,"Robert",879,30,26370,"Total Sales are: 26370"]
[null,"Jim",290,40,11600,"Total Sales are: 11600"]
[null,"Jill",580,37,21460,"Total Sales are: 21460"]
[null,"David",650,29,18850,"Total Sales are: 18850"]

{"sheet":"Flash Fill Command","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing Flash Fill Command"]
[]
[null,"Sales Person","Units","Unit Price","Total Sales","Add Text"]
[null,"John",500,25,{"$f":"C5*D5","v":12500},"Total Sales are: 12500"]
[null,"Morgan",455,31,{"$f":"C6*D6","v":14105},"Total Sales are: 14105"]
[null,"Anderson",345,23,7935,"Total Sales are: 7935"]
[null,"Robert",879,30,26370,"Total Sales are: 26370"]
[null,"Jim",290,40,11600,"Total Sales are: 11600"]
[null,"Jill",580,37,21460,"Total Sales are: 21460"]
[null,"David",650,29,18850,"Total Sales are: 18850"]

{"sheet":"Sample Data Set","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Data Set"]
[]
[null,"Sales Person","Units","Unit Price","Total Sales","Add Text"]
[null,"John",500,25,{"$f":"C5*D5","v":12500}]
[null,"Morgan",455,31,{"$f":"C6*D6","v":14105}]
[null,"Anderson",345,23,7935]
[null,"Robert",879,30,26370]
[null,"Jim",290,40,11600]
[null,"Jill",580,37,21460]
[null,"David",650,29,18850]