{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","Ampersand","Flash Fill","CONCATENATE","RIGHT, LEN, LEFT","TEXTJOIN","VBA"],"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":"Overview","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Song Name","Result"]
[null,"The Monster","The Monster.mp3"]
[null,"Timber","Timber.mp3"]
[null,"Say Something","Say Something.mp3"]
[null,"Counting Stars","Counting Stars.mp3"]
[null,"Story Of My Life","Story Of My Life.mp3"]
[null,"Demons","Demons.mp3"]
[null,"Royals","Royals.mp3"]
[null,"Let Her Go","Let Her Go.mp3"]
[null,"Roar","Roar.mp3"]
[null,"Wake me up","Wake me up.mp3"]

{"sheet":"Ampersand","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Ampersand Symbol"]
[]
[null,"Login Name","Result"]
[null,"Smith",{"$f":"\"ID: \"&B5","v":"ID: Smith"}]
[null,"Johnson",{"$f":"\"ID: \"&B6","v":"ID: Johnson"}]
[null,"Williams","ID: Williams"]
[null,"Jones","ID: Jones"]
[null,"Brown","ID: Brown"]
[null,"Davis","ID: Davis"]
[null,"Miller","ID: Miller"]
[null,"Wilson","ID: Wilson"]
[null,"Moore","ID: Moore"]
[null,"Taylor","ID: Taylor"]

{"sheet":"Flash Fill","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Application of Flash Fill Feature"]
[]
[null,"Song Name","Result"]
[null,"The Monster","The Monster.mp3"]
[null,"Timber","Timber.mp3"]
[null,"Say Something","Say Something.mp3"]
[null,"Counting Stars","Counting Stars.mp3"]
[null,"Story Of My Life","Story Of My Life.mp3"]
[null,"Demons","Demons.mp3"]
[null,"Royals","Royals.mp3"]
[null,"Let Her Go","Let Her Go.mp3"]
[null,"Roar","Roar.mp3"]
[null,"Wake me up","Wake me up.mp3"]

{"sheet":"CONCATENATE","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of CONCATENATE Function"]
[]
[null,"Song Name","Result"]
[null,"The Monster",{"$f":"CONCATENATE(\"Song: \",B5)","v":"Song: The Monster"},null,null,"Song: The Monster"]
[null,"Timber",{"$f":"CONCATENATE(\"Song: \",B6)","v":"Song: Timber"}]
[null,"Say Something","Song: Say Something"]
[null,"Counting Stars","Song: Counting Stars"]
[null,"Story Of My Life","Song: Story Of My Life"]
[null,"Demons","Song: Demons"]
[null,"Royals","Song: Royals"]
[null,"Let Her Go","Song: Let Her Go"]
[null,"Roar","Song: Roar"]
[null,"Wake me up","Song: Wake me up"]

{"sheet":"RIGHT, LEN, LEFT","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of LEFT, RIGHT, and LEN Functions"]
[]
[null,"Song Name","Result"]
[null,"The Monster",{"$f":"LEFT(B5,3)&\"-\"&RIGHT(B5,LEN(B5)-3)","v":"The- Monster"}]
[null,"Timber",{"$f":"LEFT(B6,3)&\"-\"&RIGHT(B6,LEN(B6)-3)","v":"Tim-ber"}]
[null,"Say Something","Say- Something"]
[null,"Counting Stars","Cou-nting Stars"]
[null,"Story Of My Life","Sto-ry Of My Life"]
[null,"Demons","Dem-ons"]
[null,"Royals","Roy-als"]
[null,"Let Her Go","Let- Her Go"]
[null,"Roar","Roa-r"]
[null,"Wake me up","Wak-e me up"]

{"sheet":"TEXTJOIN","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Application of TEXTJOIN Function"]
[]
[null,"Original Data","Result"]
[null,"The Monster",{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Song\",B5)","v":"Song: The Monster"}]
[null,"Timber",{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Song\",B6)","v":"Song: Timber"}]
[null,"Say Something","Song: Say Something"]
[null,"Counting Stars","Song: Counting Stars"]
[null,"Story Of My Life","Song: Story Of My Life"]
[null,"Demons","Song: Demons"]
[null,"Royals","Song: Royals"]
[null,"Let Her Go","Song: Let Her Go"]
[null,"Roar","Song: Roar"]
[null,"Wake me up","Song: Wake me up"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Application of VBA Code to Add Text"]
[]
[null,"Original Data","Result"]
[null,"The Monster","Song: The Monster"]
[null,"Timber","Song: Timber"]
[null,"Say Something","Song: Say Something"]
[null,"Counting Stars","Song: Counting Stars"]
[null,"Story Of My Life","Song: Story Of My Life"]
[null,"Demons","Song: Demons"]
[null,"Royals","Song: Royals"]
[null,"Let Her Go","Song: Let Her Go"]
[null,"Roar","Song: Roar"]
[null,"Wake me up","Song: Wake me up"]