{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sample Dataset","Functions","Combination","VBA","Practice Here"],"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":"Sample Dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Text By Space in Excel"]
[]
[null,"Names","First Name","Mid Name","Last Name"]
[null,"Mary Elizabeth Smith"]
[null,"Li Xiao Ping"]
[null,"Elizabeth Smith Brown"]
[null,"Harry S. Truman"]
[null,"John Quincy Adams"]
[null,"William Henry Harrison"]

{"sheet":"Functions","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Text By Space in Excel"]
[]
[null,"Names","First Name","Mid Name","Last Name"]
[null,"Mary Elizabeth Smith",{"$f":"LEFT(B5, FIND(\" \",B5))","v":"Mary "},{"$f":"MID(B5,FIND(\" \",B5),FIND(\" \",B5,FIND(\" \",B5)+1)-FIND(\" \", B5))","v":" Elizabeth"},{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\" \",B5,SEARCH(\" \",B5,1)+1))","v":"Smith"}]
[null,"Li Xiao Ping",{"$f":"LEFT(B6, FIND(\" \",B6))","v":"Li "},{"$f":"MID(B6,FIND(\" \",B6),FIND(\" \",B6,FIND(\" \",B6)+1)-FIND(\" \", B6))","v":" Xiao"},{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\" \",B6,SEARCH(\" \",B6,1)+1))","v":"Ping"}]
[null,"Elizabeth Smith Brown","Elizabeth "," Smith","Brown"]
[null,"Harry S. Truman","Harry "," S.","Truman"]
[null,"John Quincy Adams","John "," Quincy","Adams"]
[null,"William Henry Harrison","William "," Henry","Harrison"]

{"sheet":"Combination","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Split Text By Space in Excel"]
[]
[null,"Text","First Text","Second Text","Third Text","Fourth Text","Fifth Text"]
[null,"Hello World",{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),\n(COLUMNS($B4:B4)-1)*LEN($B5)+1,LEN($B5)))","v":"Hello"},{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),\n(COLUMNS($B4:C4)-1)*LEN($B5)+1,LEN($B5)))","v":"World"},{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),\n(COLUMNS($B4:D4)-1)*LEN($B5)+1,LEN($B5)))","v":""},{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),\n(COLUMNS($B4:E4)-1)*LEN($B5)+1,LEN($B5)))","v":""},{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",LEN($B5))),\n(COLUMNS($B4:F4)-1)*LEN($B5)+1,LEN($B5)))","v":""}]
[null,"1 2 3 4 5 ",{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),\n(COLUMNS($B5:B5)-1)*LEN($B6)+1,LEN($B6)))","v":"1"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),\n(COLUMNS($B5:C5)-1)*LEN($B6)+1,LEN($B6)))","v":"2"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),\n(COLUMNS($B5:D5)-1)*LEN($B6)+1,LEN($B6)))","v":"3"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),\n(COLUMNS($B5:E5)-1)*LEN($B6)+1,LEN($B6)))","v":"4"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\" \",REPT(\" \",LEN($B6))),\n(COLUMNS($B5:F5)-1)*LEN($B6)+1,LEN($B6)))","v":"5"}]
[null,"Elizabeth Smith Brown",{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),\n(COLUMNS($B6:B6)-1)*LEN($B7)+1,LEN($B7)))","v":"Elizabeth"},{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),\n(COLUMNS($B6:C6)-1)*LEN($B7)+1,LEN($B7)))","v":"Smith"},{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),\n(COLUMNS($B6:D6)-1)*LEN($B7)+1,LEN($B7)))","v":"Brown"},{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),\n(COLUMNS($B6:E6)-1)*LEN($B7)+1,LEN($B7)))","v":""},{"$f":"TRIM(MID(SUBSTITUTE($B7,\" \",REPT(\" \",LEN($B7))),\n(COLUMNS($B6:F6)-1)*LEN($B7)+1,LEN($B7)))","v":""}]
[null,"Harry S. Truman",{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),\n(COLUMNS($B7:B7)-1)*LEN($B8)+1,LEN($B8)))","v":"Harry"},{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),\n(COLUMNS($B7:C7)-1)*LEN($B8)+1,LEN($B8)))","v":"S."},{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),\n(COLUMNS($B7:D7)-1)*LEN($B8)+1,LEN($B8)))","v":"Truman"},{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),\n(COLUMNS($B7:E7)-1)*LEN($B8)+1,LEN($B8)))","v":""},{"$f":"TRIM(MID(SUBSTITUTE($B8,\" \",REPT(\" \",LEN($B8))),\n(COLUMNS($B7:F7)-1)*LEN($B8)+1,LEN($B8)))","v":""}]
[null,"Aa Ba Cc Dd",{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),\n(COLUMNS($B8:B8)-1)*LEN($B9)+1,LEN($B9)))","v":"Aa"},{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),\n(COLUMNS($B8:C8)-1)*LEN($B9)+1,LEN($B9)))","v":"Ba"},{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),\n(COLUMNS($B8:D8)-1)*LEN($B9)+1,LEN($B9)))","v":"Cc"},{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),\n(COLUMNS($B8:E8)-1)*LEN($B9)+1,LEN($B9)))","v":"Dd"},{"$f":"TRIM(MID(SUBSTITUTE($B9,\" \",REPT(\" \",LEN($B9))),\n(COLUMNS($B8:F8)-1)*LEN($B9)+1,LEN($B9)))","v":""}]
[null,"Jan Feb Mar Apr May",{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),\n(COLUMNS($B9:B9)-1)*LEN($B10)+1,LEN($B10)))","v":"Jan"},{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),\n(COLUMNS($B9:C9)-1)*LEN($B10)+1,LEN($B10)))","v":"Feb"},{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),\n(COLUMNS($B9:D9)-1)*LEN($B10)+1,LEN($B10)))","v":"Mar"},{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),\n(COLUMNS($B9:E9)-1)*LEN($B10)+1,LEN($B10)))","v":"Apr"},{"$f":"TRIM(MID(SUBSTITUTE($B10,\" \",REPT(\" \",LEN($B10))),\n(COLUMNS($B9:F9)-1)*LEN($B10)+1,LEN($B10)))","v":"May"}]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Text By Space in Excel"]
[]
[null,"Names","First Name","Mid Name","Last Name"]
[null,"Mary Elizabeth Smith","Mary","Elizabeth","Smith"]
[null,"Li Xiao Ping","Li","Xiao","Ping"]
[null,"Elizabeth Smith Brown","Elizabeth","Smith","Brown"]
[null,"Harry S. Truman","Harry","S.","Truman"]
[null,"John Quincy Adams","John","Quincy","Adams"]
[null,"William Henry Harrison","William","Henry","Harrison"]

{"sheet":"Practice Here","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Split Text By Space in Excel"]
[]
[null,"Text","First Text","Second Text","Third Text","Fourth Text","Fifth Text"]
[null,"Hello World"]
[null,"1 2 3 4 5 "]
[null,"Elizabeth Smith Brown"]
[null,"Harry S. Truman"]
[null,"Aa Ba Cc Dd"]
[null,"Jan Feb Mar Apr May"]