{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data Set","Left Text","Right Text","Middle Text","Extract N-th Text","Email","All Number","Extract Number after text"],"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":"Data Set","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extract Certain Text from a Cell "]
[]
[null,"Argument"]
[null,"Jessica is a beautiful girl"]
[null,"Henderson is a good student"]
[null,"Aaron lives in Dallas"]
[null,"Mitchel earns $1000 per month"]
[null,"John owns a dairy farm"]

{"sheet":"Left Text","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extract Left Text from a Cell "]
[]
[null,"Argument"]
[null,"Jessica is a beautiful girl"]
[null,"Henderson is a good student"]
[null,"Aaron lives in Dallas"]
[null,"Mitchel earns $1000 per month"]
[null,"John owns a dairy farm"]

{"sheet":"Right Text","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extract Right Text from a Cell "]
[]
[null,"Argument"]
[null,"Jessica is a beautiful girl"]
[null,"Henderson is a good student"]
[null,"Aaron lives in Dallas"]
[null,"Mitchel earns $1000 per month"]
[null,"John owns a dairy farm"]

{"sheet":"Middle Text","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extract Mid Text from a Cell "]
[]
[null,"Argument"]
[null,"Jessica is a beautiful girl"]
[null,"Henderson is a good student"]
[null,"Aaron lives in Dallas"]
[null,"Mitchel earns $1000 per month"]
[null,"John owns a dairy farm"]

{"sheet":"Extract N-th Text","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA Function to Extract N-th Text"]
[]
[null,"Argument",null,"N-th Text"]
[null,"Jessica is a beautiful girl",null,{"$f":"Required_Text(B5,4)","v":"beautiful"}]
[null,"Henderson is a good student"]
[null,"Aaron lives in Dallas"]
[null,"Mitchel earns $1000 per month"]
[null,"John owns a dairy farm"]

{"sheet":"Email","index":5,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Email from a Cell "]
[null,"."]
[null,"Argument","Email"]
[null,"Jessica, Chicago jessica875@gmail.com",{"$f":"Extract_Email(B5,$C$11)","v":"jessica875@gmail.com"}]
[null,"Henderson, Miami, henderson_hr@ibm.com",{"$f":"Extract_Email(B6,$C$11)","v":"henderson_hr@ibm.com"}]
[null,"Aaron, Dallas, aaron_2021@outlook.com",{"$f":"Extract_Email(B7,$C$11)","v":"aaron_2021@outlook.com"}]
[null,"Mitchel, Seattle, mitchel_seattle@yahoo.com",{"$f":"Extract_Email(B8,$C$11)","v":"mitchel_seattle@yahoo.com"}]
[null,"John, Houston, houston_john@gmail.com",{"$f":"Extract_Email(B9,$C$11)","v":"houston_john@gmail.com"}]
[null,null,{"$f":"Extract_Email(B10,$B$10)","v":""}]
[null,"Pattern","[\\w\\.\\-]+@[A-Za-z0-9\\.\\-]+\\.[A-Za-z]{2,24}"]
[null,null,{"$f":"Extract_Email(B12,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B13,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B14,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B15,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B16,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B17,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B18,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B19,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B20,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B21,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B22,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B23,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B24,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B25,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B26,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B27,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B28,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B29,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B30,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B31,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B32,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B33,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B34,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B35,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B36,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B37,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B38,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B39,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B40,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B41,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B42,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B43,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B44,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B45,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B46,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B47,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B48,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B49,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B50,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B51,$B$10)","v":""}]
[null,null,{"$f":"Extract_Email(B52,$B$10)","v":""}]

{"sheet":"All Number","index":6,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract All Numbers from a Cell "]
[null,"."]
[null,"Argument","Number"]
[null,"Jessica spent $200 monthly.",200]
[null,"Monthly salary of Henderson is $1500",1500]
[null,"Aaron lives in Dallas, Street No: 102",102]
[null,"Fee of gym is $100 per month",100]
[null,null,{"$f":"Extract_Email(B9,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B10,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B11,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B12,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B13,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B14,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B15,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B16,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B17,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B18,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B19,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B20,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B21,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B22,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B23,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B24,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B25,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B26,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B27,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B28,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B29,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B30,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B31,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B32,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B33,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B34,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B35,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B36,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B37,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B38,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B39,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B40,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B41,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B42,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B43,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B44,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B45,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B46,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B47,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B48,$B$9)","v":""}]
[null,null,{"$f":"Extract_Email(B49,$B$9)","v":""}]

{"sheet":"Extract Number after text","index":7,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extract Number After Specific Text"]
[]
[null,"Argument",null,"Number"]
[null,"Jessica spent $200 monthly.",null,{"$f":"Extract_number_after_text(B7,\"No: \")","v":"102"}]
[null,"Monthly salary of Henderson is $1500"]
[null,"Aaron lives in Dallas, Street No: 102"]
[null,"Fee of gym is $100 per month"]
[null,"John owns a dairy farm"]