{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Example 01","Example 02"],"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":"Sheet1","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["\\d{3}-\\d{2}-\\d{4}",null,null,null,null,null,null,null,"XXX-XX-XXXX"]
[]
["John Hopkins SSN: 123-45-7890",null,null,null,{"$f":"RegexReplace(A4,$A$2,$I$2)","v":"John Hopkins SSN: XXX-XX-XXXX"}]
["Ronnie SSN: 190-56-5210",null,null,null,{"$f":"RegexReplace(A5,$A$2,$I$2)","v":"Ronnie SSN: XXX-XX-XXXX"},null,null,null,null,{"$f":"RegexReplace(A4,A2,I2)","v":"John Hopkins SSN: XXX-XX-XXXX"}]
[null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(A4,A2,I2)","v":"John Hopkins SSN: XXX-XX-XXXX"}]
[null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(A4,A2,I2)","v":"John Hopkins SSN: XXX-XX-XXXX"}]
[]
[null,null,null,null,null,{"$f":"POWER(10,2)","v":100}]
["\\d{2}-\\d{2}-\\d{4}",null,null,null,null,null,null,null,{"$f":"REPLACE(ABCD,1,2,ABCD)","v":{"$error":"#NAME?"}}]
[]
["John Hopkins 08-03-1970",null,{"$f":"RegexReplace(A12,A10,\"*******\")","v":"John Hopkins *******"}]

{"sheet":"Example 01","index":1,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Regex in Excel",null,null,"Practice Yourself"]
[]
[null,"Name & Birthday","Result",null,"Name & Birthday","Result"]
[null,"John Kits, DOB: 08-03-1970",{"$f":"RegexReplace(B5,$C$12,$C$13)","v":"John Kits, DOB: dd-mm-yyyy"},null,"John Kits, DOB: 08-03-1970"]
[null,"Kane Williams, DOB: 08-03-1971",{"$f":"RegexReplace(B6,$C$12,$C$13)","v":"Kane Williams, DOB: dd-mm-yyyy"},null,"Kane Williams, DOB: 08-03-1971"]
[null,"Dan Brown, DOB: 08-03-1972",{"$f":"RegexReplace(B7,$C$12,$C$13)","v":"Dan Brown, DOB: dd-mm-yyyy"},null,"Dan Brown, DOB: 08-03-1972"]
[null,"Mary Ann, DOB: 08-03-1973",{"$f":"RegexReplace(B8,$C$12,$C$13)","v":"Mary Ann, DOB: dd-mm-yyyy"},null,"Mary Ann, DOB: 08-03-1973"]
[null,"Peter Trego, DOB: 08-03-1974",{"$f":"RegexReplace(B9,$C$12,$C$13)","v":"Peter Trego, DOB: dd-mm-yyyy"},null,"Peter Trego, DOB: 08-03-1974",null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B6,$C$12,$C$13)","v":"Kane Williams, DOB: dd-mm-yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B7,$C$12,$C$13)","v":"Dan Brown, DOB: dd-mm-yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B8,$C$12,$C$13)","v":"Mary Ann, DOB: dd-mm-yyyy"}]
[null,"Regex","\\d{2}-\\d{2}-\\d{4}",null,null,null,null,null,null,{"$f":"RegexReplace(B6,$C$12,$C$13)","v":"Kane Williams, DOB: dd-mm-yyyy"},null,null,null,null,null,{"$f":"RegexReplace(B9,$C$12,$C$13)","v":"Peter Trego, DOB: dd-mm-yyyy"}]
[null,"Replaced Text","dd-mm-yyyy",null,null,null,null,null,null,{"$f":"RegexReplace(B7,$C$12,$C$13)","v":"Dan Brown, DOB: dd-mm-yyyy"}]
[null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B8,$C$12,$C$13)","v":"Mary Ann, DOB: dd-mm-yyyy"}]
[null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B9,$C$12,$C$13)","v":"Peter Trego, DOB: dd-mm-yyyy"}]

{"sheet":"Example 02","index":2,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Regex in Excel",null,null,"Practise Yourself"]
[]
[null,"Name & Marks","Result",null,"Name & Marks","Result"]
[null,"John Kits, Physics: 83, Math: 92",{"$f":"RegexReplace(B5,$C$12,$C$13,2)","v":"John Kits, Physics: 83, Math: ##"},null,"John Kits, Physics: 83, Math: 92"]
[null,"Kane Williams, Physics: 78, Math: 83",{"$f":"RegexReplace(B6,$C$12,$C$13,2)","v":"Kane Williams, Physics: 78, Math: ##"},null,"Kane Williams, Physics: 78, Math: 83"]
[null,"Dan Brown, Physics: 63, Math: 74",{"$f":"RegexReplace(B7,$C$12,$C$13,2)","v":"Dan Brown, Physics: 63, Math: ##"},null,"Dan Brown, Physics: 63, Math: 74"]
[null,"Mary Ann, Physics: 84, Math: 70",{"$f":"RegexReplace(B8,$C$12,$C$13,2)","v":"Mary Ann, Physics: 84, Math: ##"},null,"Mary Ann, Physics: 84, Math: 70"]
[null,"Peter Trego, Physics: 65, Math: 67",{"$f":"RegexReplace(B9,$C$12,$C$13,2)","v":"Peter Trego, Physics: 65, Math: ##"},null,"Peter Trego, Physics: 65, Math: 67",null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B6,$C$12,$C$13)","v":"Kane Williams, Physics: ##, Math: ##"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B7,$C$12,$C$13)","v":"Dan Brown, Physics: ##, Math: ##"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B8,$C$12,$C$13)","v":"Mary Ann, Physics: ##, Math: ##"}]
[null,"Regex","\\d+",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RegexReplace(B9,$C$12,$C$13)","v":"Peter Trego, Physics: ##, Math: ##"}]
[null,"Replaced Text","##"]