{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Find and Replace","TEXTBEFORE Function","LEFT & SEARCH Function","LEFT,FIND & SUBSTITUTE","LEFT,FIND,LEN and SUBSTITUTE","Flash Fill","User Defined Function","Exercise"],"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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dataset"]
[]
[null,"Data"]
[null,"Christian-Pulisic-Footballer"]
[null,"Josh-Buttler-Cricketer"]
[null,"Joe-Root-Cricketer"]
[null,"David-Malan-Cricketer"]
[null,"Eoin-Morgan-Cricketer"]
[null,"Tyler-Adams-Footballer"]
[null,"Joe-Scally-Footballer"]
[null,"Dan-Carter-RugbyPlayer"]

{"sheet":"Find and Replace","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Find and Replace Command"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer","Christian"]
[null,"Josh-Buttler-Cricketer","Josh"]
[null,"Joe-Root-Cricketer","Joe"]
[null,"David-Malan-Cricketer","David"]
[null,"Eoin-Morgan-Cricketer","Eoin"]
[null,"Tyler-Adams-Footballer","Tyler"]
[null,"Joe-Scally-Footballer","Joe"]
[null,"Dan-Carter-RugbyPlayer","Dan"]

{"sheet":"TEXTBEFORE Function","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using TEXTBEFORE Function"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer","Christian"]
[null,"Josh-Buttler-Cricketer","Josh"]
[null,"Joe-Root-Cricketer","Joe"]
[null,"David-Malan-Cricketer","David"]
[null,"Eoin-Morgan-Cricketer","Eoin"]
[null,"Tyler-Adams-Footballer","Tyler"]
[null,"Joe-Scally-Footballer","Joe"]
[null,"Dan-Carter-RugbyPlayer","Dan"]

{"sheet":"LEFT & SEARCH Function","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using LEFT and SEARCH Functions"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer",{"$f":"LEFT(B5, SEARCH(\"-\", B5) -1)","v":"Christian"}]
[null,"Josh-Buttler-Cricketer",{"$f":"LEFT(B6, SEARCH(\"-\", B6) -1)","v":"Josh"}]
[null,"Joe-Root-Cricketer","Joe"]
[null,"David-Malan-Cricketer","David"]
[null,"Eoin-Morgan-Cricketer","Eoin"]
[null,"Tyler-Adams-Footballer","Tyler"]
[null,"Joe-Scally-Footballer","Joe"]
[null,"Dan-Carter-RugbyPlayer","Dan"]

{"sheet":"LEFT,FIND & SUBSTITUTE","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using LEFT,FIND & SUBSTITUTE Functions"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer",{"$f":"LEFT(B5, FIND(\"#\", SUBSTITUTE(B5, \"-\", \"#\", 2)) -1)","v":"Christian-Pulisic"}]
[null,"Josh-Buttler-Cricketer",{"$f":"LEFT(B6, FIND(\"#\", SUBSTITUTE(B6, \"-\", \"#\", 2)) -1)","v":"Josh-Buttler"}]
[null,"Joe-Root-Cricketer","Joe-Root"]
[null,"David-Malan-Cricketer","David-Malan"]
[null,"Eoin-Morgan-Cricketer","Eoin-Morgan"]
[null,"Tyler-Adams-Footballer","Tyler-Adams"]
[null,"Joe-Scally-Footballer","Joe-Scally"]
[null,"Dan-Carter-RugbyPlayer","Dan-Carter"]

{"sheet":"LEFT,FIND,LEN and SUBSTITUTE","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using LEFT,FIND,LEN & SUBSTITUTE Functions"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer",{"$f":"LEFT(B5, FIND(\"#\", SUBSTITUTE(B5, \"-\", \"#\",LEN(B5) - LEN(SUBSTITUTE(B5, \"-\",\"\")))) -1)","v":"Christian-Pulisic"}]
[null,"Josh-Buttler-Cricketer",{"$f":"LEFT(B6, FIND(\"#\", SUBSTITUTE(B6, \"-\", \"#\",\nLEN(B6) - LEN(SUBSTITUTE(B6, \"-\",\"\")))) -1)","v":"Josh-Buttler"}]
[null,"Joe-Root-Cricketer","Joe-Root"]
[null,"David-Malan-Cricketer","David-Malan"]
[null,"Eoin-Morgan-Cricketer","Eoin-Morgan"]
[null,"Tyler-Adams-Footballer","Tyler-Adams"]
[null,"Joe-Scally-Footballer","Joe-Scally"]
[null,"Dan-Carter-RugbyPlayer","Dan-Carter"]

{"sheet":"Flash Fill","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Flash Fill Feature"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer","Christian"]
[null,"Josh-Buttler-Cricketer","Josh"]
[null,"Joe-Root-Cricketer","Joe"]
[null,"David-Malan-Cricketer","David"]
[null,"Eoin-Morgan-Cricketer","Eoin"]
[null,"Tyler-Adams-Footballer","Tyler"]
[null,"Joe-Scally-Footballer","Joe"]
[null,"Dan-Carter-RugbyPlayer","Dan"]

{"sheet":"User Defined Function","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using User Defined Function"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer",{"$f":"LEFT(B5,Truncate(B5,\"-\")-1)","v":"Christian-Pulisic"}]
[null,"Josh-Buttler-Cricketer",{"$f":"LEFT(B6,Truncate(B6,\"-\")-1)","v":"Josh-Buttler"}]
[null,"Joe-Root-Cricketer","Joe-Root"]
[null,"David-Malan-Cricketer","David-Malan"]
[null,"Eoin-Morgan-Cricketer","Eoin-Morgan"]
[null,"Tyler-Adams-Footballer","Tyler-Adams"]
[null,"Joe-Scally-Footballer","Joe-Scally"]
[null,"Dan-Carter-RugbyPlayer","Dan-Carter"]

{"sheet":"Exercise","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Try Yourself"]
[]
[null,"Data","Result"]
[null,"Christian-Pulisic-Footballer"]
[null,"Josh-Buttler-Cricketer"]
[null,"Joe-Root-Cricketer"]
[null,"David-Malan-Cricketer"]
[null,"Eoin-Morgan-Cricketer"]
[null,"Tyler-Adams-Footballer"]
[null,"Joe-Scally-Footballer"]
[null,"Dan-Carter-RugbyPlayer"]