{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","TRIM,LEFT,FIND","SEARCH, TRIM","SUBSTITUTE AND LEN","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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Space Before Text"]
[]
[null,"Texts","Number of Spaces"]
[null,"Excel"]
[null,"  Microsoft"]
[null," Excel365"]
[null,"      Excel2019"]
[null,"   Powerpoint"]

{"sheet":"TRIM,LEFT,FIND","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Space Before Text"]
[]
[null,"Texts","Number of Spaces"]
[null,"Excel",{"$f":"FIND(LEFT(TRIM(B5),1),B5)-1","v":0}]
[null,"  Microsoft",{"$f":"FIND(LEFT(TRIM(B6),1),B6)-1","v":2}]
[null," Excel365",1]
[null,"      Excel2019",6]
[null,"   Powerpoint",3]

{"sheet":"SEARCH, TRIM","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Space Before Text"]
[]
[null,"Texts","Number of Spaces"]
[null,"Excel",{"$f":"SEARCH(TRIM(B5),B5)-1","v":0}]
[null,"  Microsoft",{"$f":"SEARCH(TRIM(B6),B6)-1","v":2}]
[null," Excel365",1]
[null,"      Excel2019",6]
[null,"   Powerpoint",3]

{"sheet":"SUBSTITUTE AND LEN","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Space Before Text"]
[]
[null,"Texts","Number of Spaces"]
[null,"Excel",{"$f":"LEN(B5)-LEN(SUBSTITUTE(B5,\" \",\"\"))","v":0}]
[null,"  Microsoft",{"$f":"LEN(B6)-LEN(SUBSTITUTE(B6,\" \",\"\"))","v":2}]
[null," Excel365",1]
[null,"      Excel2019",6]
[null,"   Powerpoint",3]

{"sheet":"VBA","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Space Before Text"]
[]
[null,"Texts","Number of Spaces"]
[null,"Excel",{"$f":"NumSpacesStart(B5)","v":0}]
[null,"  Microsoft",{"$f":"NumSpacesStart(B6)","v":2}]
[null," Excel365",{"$f":"NumSpacesStart(B7)","v":1}]
[null,"      Excel2019",{"$f":"NumSpacesStart(B8)","v":6}]
[null,"   Powerpoint",{"$f":"NumSpacesStart(B9)","v":3}]