{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"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":"Sheet1","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Separate Functions"]
[null,"RemoveNonAlphas","RemoveAlphas","RemoveNonNumerics"]
["ab##c xyz 136&$546",{"$f":"RemoveNonAlphas(A9)","v":"abcxyz"},{"$f":"removealphas(A9)","v":"##  136&$546"},{"$f":"removenonnumerics(A9)","v":"136546"}]
["abc-de-xy z# 1364762 z",{"$f":"RemoveNonAlphas(A10)","v":"abcdexyzz"},{"$f":"removealphas(A10)","v":"-- # 1364762 "},{"$f":"removenonnumerics(A10)","v":"1364762"}]
["a-b-c de f 1389#064#6 zz","abcdefzz","--   1389#064#6 ","13890646"]
["12 5 ab cd ef g qr x y  1363  5 99--) z 546","abcdefgqrxyz","12 5         1363  5 99--)  546","1251363599546"]
[]
[null,"CLEANSTRING Function"]
["ab##c xyz 136&$546",{"$f":"cleanstring(A15,1)","v":"abcxyz"},{"$f":"cleanstring(A15,2)","v":"##  136&$546"},{"$f":"cleanstring(A15,3)","v":"136546"}]
["abc-de-xy z# 1364762 z",{"$f":"cleanstring(A16,1)","v":"abcdexyzz"},{"$f":"cleanstring(A16,2)","v":"-- # 1364762 "},{"$f":"cleanstring(A16,3)","v":"1364762"}]
["a-b-c de f 1389#064#6 zz","abcdefzz",{"$f":"cleanstring(A17,2)","v":"--   1389#064#6 "},{"$f":"cleanstring(A17,3)","v":"13890646"}]
["12 5 ab cd ef g qr x y  1363  5 99--) z 546","abcdefgqrxyz","12 5         1363  5 99--)  546","1251363599546"]
[]
[]
["Other Resources","Our Courses"]
["Blog","Excel Dashboards"]
["Free Training","Power Query"]
["Excel Forum","Power Pivot"]
[null,"Pivot Tables"]
[null,"Excel Expert"]
[null,"Excel for Decision Making"]
[null,"Excel for Finance"]
[null,"Excel for Customer Service Professionals"]