{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["IF, ISERROR, VALUE, LEFT & FIND","IF, ISNUMBER, VALUE, LEFT FIND","LEFT & FIND","Text to Columns","VBA","flash fill"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"IF, ISERROR, VALUE, LEFT & FIND","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combination of IF, ISERROR, VALUE, LEFT & FIND Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number",null,null,null,null,"Address","Address Number"]
[null,"711-2880 Nulla St., Mankato, Mississippi 96522",{"$f":"IF(ISERROR(VALUE(LEFT(B5,1))),\"\",LEFT(B5,FIND(\" \",B5)-1))","v":"711-2880"},null,null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283-8562 Fusce Rd., Frederick, Nebraska 20620",{"$f":"IF(ISERROR(VALUE(LEFT(B6,1))),\"\",LEFT(B6,FIND(\" \",B6)-1))","v":"283-8562"},null,null,null,null,"283 8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606-3727 Ullamcorper. Street, Roseville, NH 11523","606-3727",null,null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935-9940 Tortor. Street, Santa Rosa, MN 98804","935-9940",null,null,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]

{"sheet":"IF, ISNUMBER, VALUE, LEFT FIND","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combination of IF, ISNUMBER, VALUE, LEFT & FIND Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number",null,null,null,null,"Address","Address Number"]
[null,"711-2880 Nulla St., Mankato, Mississippi 96522",{"$f":"IF(ISNUMBER(VALUE(LEFT(B5,1))),LEFT(B5,FIND(\" \",B5)-1),\"\")","v":"711-2880"},null,null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283-8562 Fusce Rd., Frederick, Nebraska 20620",{"$f":"IF(ISNUMBER(VALUE(LEFT(B6,1))),LEFT(B6,FIND(\" \",B6)-1),\"\")","v":"283-8562"},null,null,null,null,"283 8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606-3727 Ullamcorper. Street, Roseville, NH 11523","606-3727",null,null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935-9940 Tortor. Street, Santa Rosa, MN 98804","935-9940",null,null,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]

{"sheet":"LEFT & FIND","index":2,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Combination of LEFT & FIND Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number",null,null,null,null,null,"Address","Address Number"]
[null,"711-2880 Nulla St., Mankato, Mississippi 96522",{"$f":"LEFT(B5,FIND(\" \",B5,1))","v":"711-2880 "},null,null,null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283-8562 Fusce Rd., Frederick, Nebraska 20620",{"$f":"LEFT(B6,FIND(\" \",B6,1))","v":"283-8562 "},null,null,null,null,null,"283 8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606-3727 Ullamcorper. Street, Roseville, NH 11523","606-3727 ",null,null,null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935-9940 Tortor. Street, Santa Rosa, MN 98804","935-9940 ",null,null,null,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]

{"sheet":"Text to Columns","index":3,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,1,1,8]]}
[]
[null,"Use of Text to Columns Feature",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number",null,null,null,null,null,null,null,null,"Address","Address Number"]
[null,"711-2880 Nulla St., Mankato, Mississippi 96522","711-2880","Nulla","St.,","Mankato,","Mississippi",96522,null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283-8562 Fusce Rd., Frederick, Nebraska 20620","283-8562","Fusce","Rd.,","Frederick,","Nebraska",20620,null,null,null,"283-8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606-3727 Ullamcorper. Street, Roseville, NH 11523","606-3727","Ullamcorper.","Street,","Roseville,","NH",11523,null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935-9940 Tortor. Street, Santa Rosa, MN 98804","935-9940","Tortor.","Street,","Santa","Rosa,","MN",98804,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]

{"sheet":"VBA","index":4,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,8]]}
[]
[null,"Use of VBA Method",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number",null,null,null,null,"Address","Address Number"]
[null,"711 Nulla St., Mankato, Mississippi 96522",711,"Nulla St., Mankato, Mississippi 96522",null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283 Fusce Rd., Frederick, Nebraska 20620",283,"Fusce Rd., Frederick, Nebraska 20620",null,null,null,"283 8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606 Ullamcorper. Street, Roseville, NH 11523",606,"Ullamcorper. Street, Roseville, NH 11523",null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935 Tortor. Street, Santa Rosa, MN 98804",935,"Tortor. Street, Santa Rosa, MN 98804",null,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]

{"sheet":"flash fill","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,10]]}
[]
[null,"Use of Flash Fill Feature",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Address","Address Number","Street","City","State",null,null,null,"Address","Address Number"]
[null,"711-2880 Nulla St., Mankato, Mississippi 96522","711-2880","Nulla St.","Mankato","Mississippi 96522",null,null,null,"711-2880 Nulla St., Mankato, Mississippi 96522"]
[null,"283-8562 Fusce Rd., Frederick, Nebraska 20620","283-8562","Fusce Rd.","Frederick","Nebraska 20620",null,null,null,"283 8562 Fusce Rd., Frederick, Nebraska 20620"]
[null,"606-3727 Ullamcorper. Street, Roseville, NH 11523","606-3727","Ullamcorper. Street","Roseville","NH 11523",null,null,null,"606-3727 Ullamcorper. Street, Roseville, NH 11523"]
[null,"935-9940 Tortor. Street, Santa Rosa, MN 98804","935-9940","Tortor. Street","Santa Rosa","MN 98804",null,null,null,"935-9940 Tortor. Street, Santa Rosa, MN 98804"]