{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["UDF functions","Examples"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"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":"UDF functions","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,5,8],[8,2,8,3],[3,1,3,8]]}
[]
[]
[]
[null,"Sample Workbook to Recursive User-Defined Functions"]
[]
[null,"The workbook contains a few examples of user-defined functions to remove unwanted characters."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-05-28"]
[null,"Tutorial URL","How to write recursive LAMBDA function in Excel"]
[]
[null,"The workbook contains the following functions"]
["• ","RemoveCharsRecursive - remove unwanted characters non-recursive"]
["• ","RemoveCharsNonRecursive - non-recursive UDF to remove characters"]
["• ","RemoveCharsNonRecursive2 - another non-recursive UDF to remove chars"]

{"sheet":"Examples","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Source data","Recursive UDF","Non-recursive UDF 1","Non-recursive UDF 2",null,"Chars to remove"]
["_USA,^ NC*",{"$f":"RemoveCharsRecursive(A2, $F$2)","v":"USA, NC"},{"$f":"RemoveCharsNonRecursive(B2, $F$2)","v":"USA, NC"},{"$f":"RemoveCharsNonRecursive2(A2, $F$2)","v":"USA, NC"},null,"_^*/&%"]
["UK, _Avon",{"$f":"RemoveCharsRecursive(A3, $F$2)","v":"UK, Avon"},{"$f":"RemoveCharsNonRecursive(B3, $F$2)","v":"UK, Avon"},{"$f":"RemoveCharsNonRecursive2(A3, $F$2)","v":"UK, Avon"}]
["%&USA, IL",{"$f":"RemoveCharsRecursive(A4, $F$2)","v":"USA, IL"},{"$f":"RemoveCharsNonRecursive(B4, $F$2)","v":"USA, IL"},{"$f":"RemoveCharsNonRecursive2(A4, $F$2)","v":"USA, IL"}]
["USA, KS */",{"$f":"RemoveCharsRecursive(A5, $F$2)","v":"USA, KS "},{"$f":"RemoveCharsNonRecursive(B5, $F$2)","v":"USA, KS "},{"$f":"RemoveCharsNonRecursive2(A5, $F$2)","v":"USA, KS "}]
["UK, & Blackpool",{"$f":"RemoveCharsRecursive(A6, $F$2)","v":"UK,  Blackpool"},{"$f":"RemoveCharsNonRecursive(B6, $F$2)","v":"UK,  Blackpool"},{"$f":"RemoveCharsNonRecursive2(A6, $F$2)","v":"UK,  Blackpool"}]
["USA, MO",{"$f":"RemoveCharsRecursive(A7, $F$2)","v":"USA, MO"},{"$f":"RemoveCharsNonRecursive(B7, $F$2)","v":"USA, MO"},{"$f":"RemoveCharsNonRecursive2(A7, $F$2)","v":"USA, MO"}]
["_USA, NM",{"$f":"RemoveCharsRecursive(A8, $F$2)","v":"USA, NM"},{"$f":"RemoveCharsNonRecursive(B8, $F$2)","v":"USA, NM"},{"$f":"RemoveCharsNonRecursive2(A8, $F$2)","v":"USA, NM"}]
["USA, &*AZ",{"$f":"RemoveCharsRecursive(A9, $F$2)","v":"USA, AZ"},{"$f":"RemoveCharsNonRecursive(B9, $F$2)","v":"USA, AZ"},{"$f":"RemoveCharsNonRecursive2(A9, $F$2)","v":"USA, AZ"}]
["UK, Hampshire%",{"$f":"RemoveCharsRecursive(A10, $F$2)","v":"UK, Hampshire"},{"$f":"RemoveCharsNonRecursive(B10, $F$2)","v":"UK, Hampshire"},{"$f":"RemoveCharsNonRecursive2(A10, $F$2)","v":"UK, Hampshire"}]