{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["SUBSTITUE","TEXTSPLIT","MID","TEXTAFTER","RIGHT-LEN","RIGHT-FIND"],"read":"whole","date_system":"1900"}

{"sheet":"SUBSTITUE","index":0,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"TRIM(MID(SUBSTITUTE(A2,\" \",REPT(\" \",LEN(A2))),(2-1)*LEN(A2)+1,LEN(A2)))","v":"Beta"}]
["Beta Gamma Two",{"$f":"TRIM(MID(SUBSTITUTE(A3,\" \",REPT(\" \",LEN(A3))),(2-1)*LEN(A3)+1,LEN(A3)))","v":"Gamma"}]
["Gamma Delta Three","Delta"]
["Delta Epsilon Four","Epsilon"]
["Epsilon Zeta Five","Zeta"]
["Zeta Eta Six","Eta"]
["Eta Theta Seven","Theta"]
["Theta Iota Eight","Iota"]
["Iota Kappa Nine","Kappa"]
["Kappa Lambda Ten","Lambda"]

{"sheet":"TEXTSPLIT","index":1,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"INDEX(TEXTSPLIT(A2,\" \"),2)","v":{"$error":"#NAME?"}}]
["Beta Gamma Two",{"$f":"INDEX(TEXTSPLIT(A3,\" \"),2)","v":{"$error":"#NAME?"}}]
["Gamma Delta Three",{"$f":"INDEX(TEXTSPLIT(A4,\" \"),2)","v":{"$error":"#NAME?"}}]
["Delta Epsilon Four",{"$f":"INDEX(TEXTSPLIT(A5,\" \"),2)","v":{"$error":"#NAME?"}}]
["Epsilon Zeta Five",{"$f":"INDEX(TEXTSPLIT(A6,\" \"),2)","v":{"$error":"#NAME?"}}]
["Zeta Eta Six",{"$f":"INDEX(TEXTSPLIT(A7,\" \"),2)","v":{"$error":"#NAME?"}}]
["Eta Theta Seven",{"$f":"INDEX(TEXTSPLIT(A8,\" \"),2)","v":{"$error":"#NAME?"}}]
["Theta Iota Eight",{"$f":"INDEX(TEXTSPLIT(A9,\" \"),2)","v":{"$error":"#NAME?"}}]
["Iota Kappa Nine",{"$f":"INDEX(TEXTSPLIT(A10,\" \"),2)","v":{"$error":"#NAME?"}}]
["Kappa Lambda Ten",{"$f":"INDEX(TEXTSPLIT(A11,\" \"),2)","v":{"$error":"#NAME?"}}]

{"sheet":"MID","index":2,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"MID(A2, 7, LEN(A2))","v":"Beta One"}]
["Beta Gamma Two",{"$f":"MID(A3, 7, LEN(A3))","v":"amma Two"}]
["Gamma Delta Three","Delta Three"]
["Delta Epsilon Four","Epsilon Four"]
["Epsilon Zeta Five","n Zeta Five"]
["Zeta Eta Six","ta Six"]
["Eta Theta Seven","eta Seven"]
["Theta Iota Eight","Iota Eight"]
["Iota Kappa Nine","appa Nine"]
["Kappa Lambda Ten","Lambda Ten"]

{"sheet":"TEXTAFTER","index":3,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"TEXTAFTER(A2, \" \")","v":{"$error":"#NAME?"}}]
["Beta Gamma Two",{"$f":"TEXTAFTER(A3, \" \")","v":{"$error":"#NAME?"}}]
["Gamma Delta Three",{"$error":"#NAME?"}]
["Delta Epsilon Four",{"$error":"#NAME?"}]
["Epsilon Zeta Five",{"$error":"#NAME?"}]
["Zeta Eta Six",{"$error":"#NAME?"}]
["Eta Theta Seven",{"$error":"#NAME?"}]
["Theta Iota Eight",{"$error":"#NAME?"}]
["Iota Kappa Nine",{"$error":"#NAME?"}]
["Kappa Lambda Ten",{"$error":"#NAME?"}]

{"sheet":"RIGHT-LEN","index":4,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"RIGHT(A2,LEN(A2)-6)","v":"Beta One"}]
["Beta Gamma Two",{"$f":"RIGHT(A3,LEN(A3)-6)","v":"amma Two"}]
["Gamma Delta Three","Delta Three"]
["Delta Epsilon Four","Epsilon Four"]
["Epsilon Zeta Five","n Zeta Five"]
["Zeta Eta Six","ta Six"]
["Eta Theta Seven","eta Seven"]
["Theta Iota Eight","Iota Eight"]
["Iota Kappa Nine","appa Nine"]
["Kappa Lambda Ten","Lambda Ten"]

{"sheet":"RIGHT-FIND","index":5,"n_rows":11,"n_cols":2,"rows_kept":11}
["Text","Extracted Text"]
["Alpha Beta One",{"$f":"RIGHT(A2,LEN(A2)-FIND(\" \",A2))","v":"Beta One"}]
["Beta Gamma Two",{"$f":"RIGHT(A3,LEN(A3)-FIND(\" \",A3))","v":"Gamma Two"}]
["Gamma Delta Three","Delta Three"]
["Delta Epsilon Four","Epsilon Four"]
["Epsilon Zeta Five","Zeta Five"]
["Zeta Eta Six","Eta Six"]
["Eta Theta Seven","Theta Seven"]
["Theta Iota Eight","Iota Eight"]
["Iota Kappa Nine","Kappa Nine"]
["Kappa Lambda Ten","Lambda Ten"]