{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Overview","Dataset","Flash Fill","Text to Columns","TRIM,MID,SUBSTITUTE,REPT,LEN","TEXTJOIN","SEARCH,IF,ISERROR,TEXTJOIN","TEXTJOIN, IF, ISERROR","FILTER, TOCOL, ISNUMBER","INDEX, MATCH","VBA","User Name","Outlook"],"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":"Overview","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Overview of Extracting Email Addresses from Excel",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address",null,null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999","emily.wilson@outlook.com",null,null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666",null,null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444",null,null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333",null,null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666",null,null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777",null,null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555",null,null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888",null,null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"Dataset","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extracting Email Addresses from Excel"]
[]
[null,"Employee Name, Email and Contact Number"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"Flash Fill","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Using Flash Fill Feature",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address",null,null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999","emily.wilson@outlook.com",null,null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666","michael.brown33@gmail.com",null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444","sarah.davis21@hotmail.com",null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333","robert.lee89@yahoo.com",null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666","jennifer.clark29@example.com",null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777","william.brown789@jet.com",null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555","andrew.wilson1973@outlook.com",null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888","olivia.davis45@gmail.com",null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"Text to Columns","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Utilizing Text to Columns Feature",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Address and Contact Number","Extracted Email Address",null,null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"," emily.wilson@outlook.com",null,null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"," michael.brown33@gmail.com",null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"," sarah.davis21@hotmail.com",null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"," robert.lee89@yahoo.com",null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"," jennifer.clark29@example.com",null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777"," william.brown789@jet.com",null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"," andrew.wilson1973@outlook.com",null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"," olivia.davis45@gmail.com",null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"TRIM,MID,SUBSTITUTE,REPT,LEN","index":4,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Utilizing TRIM, MID, SUBSTITUTE, REPT, LEN, LEFT, SEARCH Functions",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Address and Contact Number","Extracted Email Address",null,null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999",{"$f":"SUBSTITUTE(TRIM(MID(SUBSTITUTE(TRIM(B5),\" \",REPT(\" \",200)), (LEN(LEFT(B5,SEARCH(\"@\",B5)))-LEN(SUBSTITUTE(LEFT(B5,SEARCH(\"@\",B5)),\" \", \"\")))*200+1, 200)), \",\", \"\")","v":"emily.wilson@outlook.com"},null,null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666",{"$f":"SUBSTITUTE(TRIM(MID(SUBSTITUTE(TRIM(B6),\" \",REPT(\" \",200)), (LEN(LEFT(B6,SEARCH(\"@\",B6)))-LEN(SUBSTITUTE(LEFT(B6,SEARCH(\"@\",B6)),\" \", \"\")))*200+1, 200)), \",\", \"\")","v":"michael.brown33@gmail.com"},null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444","sarah.davis21@hotmail.com",null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333","robert.lee89@yahoo.com",null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666","jennifer.clark29@example.com",null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777","william.brown789@jet.com",null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555","andrew.wilson1973@outlook.com",null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888","olivia.davis45@gmail.com",null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"TEXTJOIN","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,2,11,2],[1,1,1,3],[1,12,1,13],[4,3,11,3]]}
[]
[null,"Applying TEXTJOIN, CHAR, IF, ISERROR, SEARCH, TRIM, MID, SUBSTITUTE, REPT, LEN, LEFT, SUBSTITUTE Functions",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Address and Contact Number",null,"Extracted Email Address",null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999",null,{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,IF(ISERROR(SEARCH(\"@\",B5:B12)),\"\",TRIM(MID(SUBSTITUTE(TRIM(B5:B12),\" \",REPT(\" \",200)),(LEN(LEFT(B5:B12,SEARCH(\"@\",B5:B12)))-LEN(SUBSTITUTE(LEFT(B5:B12,SEARCH(\"@\",B5:B12)),\" \",\"\")))*200+1,200))))","v":"emily.wilson@outlook.com,\nmichael.brown33@gmail.com,\nsarah.davis21@hotmail.com,\nrobert.lee89@yahoo.com,\njennifer.clark29@example.com,\nwilliam.brown789@jet.com,\nandrew.wilson1973@outlook.com,\nolivia.davis45@gmail.com,"},null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com, 777-888-9999"]
[null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666",null,null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com, 444-555-6666"]
[null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444",null,null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com, 222-333-4444"]
[null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333",null,null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com, 111-222-3333"]
[null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666",null,null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com, 888-777-6666"]
[null,"William Brown, william.brown789@jet.com, 999-888-7777",null,null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com, 999-888-7777"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555",null,null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888",null,null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"SEARCH,IF,ISERROR,TEXTJOIN","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Combining SEARCH, ISERROR, IF and TEXTJOIN Functions",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Address","Extracted Email Address",null,null,null,null,null,null,null,null,null,"Employee Name, Email Adddress and Contact Number","Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com",{"$f":"IF(ISERROR(SEARCH(\"@\", B5)), \"\", MID(B5, SEARCH(\",\", B5) + 2, LEN(B5) - SEARCH(\",\", B5) - 1))","v":"emily.wilson@outlook.com"},null,null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com"]
[null,"Michael Brown, michael.brown33@gmail.com",{"$f":"IF(ISERROR(SEARCH(\"@\", B6)), \"\", MID(B6, SEARCH(\",\", B6) + 2, LEN(B6) - SEARCH(\",\", B6) - 1))","v":"michael.brown33@gmail.com"},null,null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com"]
[null,"Sarah Davis, sarah.davis21@hotmail.com","sarah.davis21@hotmail.com",null,null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com"]
[null,"Robert Lee, robert.lee89@yahoo.com","robert.lee89@yahoo.com",null,null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com"]
[null,"Jennifer Clark, jennifer.clark29@example.com","jennifer.clark29@example.com",null,null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com"]
[null,"William Brown, william.brown789@jet.com","william.brown789@jet.com",null,null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com","andrew.wilson1973@outlook.com",null,null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com"]
[null,"Olivia Davis, olivia.davis45@gmail.com","olivia.davis45@gmail.com",null,null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com"]

{"sheet":"TEXTJOIN, IF, ISERROR","index":7,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,14,1,18],[3,1,3,3],[3,14,3,16],[4,5,11,5]]}
[]
[null,"Combining TEXTJOIN, IF, ISERROR, SEARCH Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Information",null,null,null,"Extracted Email Address",null,null,null,null,null,null,null,null,"Employee Information",null,null,null,"Extracted Email Address"]
[null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis",null,{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF(ISERROR(SEARCH(\"@\", B5:D12)), \"\", B5:D12))","v":"andrew.wilson1973@outlook.com, robert.lee89@yahoo.com, jennifer.clark29@example.com, emily.wilson@outlook.com, sarah.davis21@hotmail.com, michael.brown33@gmail.com, olivia.davis45@gmail.com, william.brown789@jet.com"},null,null,null,null,null,null,null,null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis"]
[null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777",null,null,null,null,null,null,null,null,null,null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777"]
[null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com",null,null,null,null,null,null,null,null,null,null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com"]
[null,"emily.wilson@outlook.com","222-333-4444","777-222-5555",null,null,null,null,null,null,null,null,null,null,"emily.wilson@outlook.com","222-333-4444","777-222-5555"]
[null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson",null,null,null,null,null,null,null,null,null,null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson"]
[null,"444-555-6666","William Brown","michael.brown33@gmail.com",null,null,null,null,null,null,null,null,null,null,"444-555-6666","William Brown","michael.brown33@gmail.com"]
[null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888",null,null,null,null,null,null,null,null,null,null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888"]
[null,"Robert Lee","william.brown789@jet.com","Robert Lee",null,null,null,null,null,null,null,null,null,null,"Robert Lee","william.brown789@jet.com","Robert Lee"]

{"sheet":"FILTER, TOCOL, ISNUMBER","index":8,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,14,1,18],[3,1,3,3],[3,14,3,16]]}
[]
[null,"Combining FILTER, TOCOL, ISNUMBER, SEARCH Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Information",null,null,null,"Extracted Email Address",null,null,null,null,null,null,null,null,"Employee Information",null,null,null,"Extracted Email Address"]
[null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis",null,{"$f":"_xlfn._xlws.FILTER(_xlfn.TOCOL(B5:D12),ISNUMBER(SEARCH(\"@\",_xlfn.TOCOL(B5:D12))))","v":"andrew.wilson1973@outlook.com"},null,null,null,null,null,null,null,null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis"]
[null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777",null,"robert.lee89@yahoo.com",null,null,null,null,null,null,null,null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777"]
[null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com",null,"jennifer.clark29@example.com",null,null,null,null,null,null,null,null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com"]
[null,"emily.wilson@outlook.com","222-333-4444","777-222-5555",null,"emily.wilson@outlook.com",null,null,null,null,null,null,null,null,"emily.wilson@outlook.com","222-333-4444","777-222-5555"]
[null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson",null,"sarah.davis21@hotmail.com",null,null,null,null,null,null,null,null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson"]
[null,"444-555-6666","William Brown","michael.brown33@gmail.com",null,"michael.brown33@gmail.com",null,null,null,null,null,null,null,null,"444-555-6666","William Brown","michael.brown33@gmail.com"]
[null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888",null,"olivia.davis45@gmail.com",null,null,null,null,null,null,null,null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888"]
[null,"Robert Lee","william.brown789@jet.com","Robert Lee",null,"william.brown789@jet.com",null,null,null,null,null,null,null,null,"Robert Lee","william.brown789@jet.com","Robert Lee"]

{"sheet":"INDEX, MATCH","index":9,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,3],[1,14,1,18],[3,14,3,16]]}
[]
[null,"Using INDEX, MATCH, COLUMN, SEARCH, ISERROR, IF and MIN Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Information",null,null,null,"Extracted Email Address",null,null,null,null,null,null,null,null,"Employee Information",null,null,null,"Extracted Email Address"]
[null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis",null,{"$f":"INDEX(B5:D5,1,MIN(IF(ISERROR(SEARCH(\"@\",B5:D5)),\"\",MATCH(COLUMN(B5:D5),COLUMN(B5:D5)))))","v":"andrew.wilson1973@outlook.com"},null,null,null,null,null,null,null,null,"Emily Wilson","andrew.wilson1973@outlook.com","Sarah Davis"]
[null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777",null,{"$f":"INDEX(B6:D6,1,MIN(IF(ISERROR(SEARCH(\"@\",B6:D6)),\"\",MATCH(COLUMN(B6:D6),COLUMN(B6:D6)))))","v":"robert.lee89@yahoo.com"},null,null,null,null,null,null,null,null,"777-888-9999","robert.lee89@yahoo.com"," 999-888-7777"]
[null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com",null,{"$f":"INDEX(B7:D7,1,MIN(IF(ISERROR(SEARCH(\"@\",B7:D7)),\"\",MATCH(COLUMN(B7:D7),COLUMN(B7:D7)))))","v":"jennifer.clark29@example.com"},null,null,null,null,null,null,null,null,"Olivia Davis","Michael Brown","jennifer.clark29@example.com"]
[null,"emily.wilson@outlook.com","222-333-4444","777-222-5555",null,{"$f":"INDEX(B8:D8,1,MIN(IF(ISERROR(SEARCH(\"@\",B8:D8)),\"\",MATCH(COLUMN(B8:D8),COLUMN(B8:D8)))))","v":"emily.wilson@outlook.com"},null,null,null,null,null,null,null,null,"emily.wilson@outlook.com","222-333-4444","777-222-5555"]
[null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson",null,{"$f":"INDEX(B9:D9,1,MIN(IF(ISERROR(SEARCH(\"@\",B9:D9)),\"\",MATCH(COLUMN(B9:D9),COLUMN(B9:D9)))))","v":"sarah.davis21@hotmail.com"},null,null,null,null,null,null,null,null,"sarah.davis21@hotmail.com","888-777-6666","Andrew Wilson"]
[null,"444-555-6666","William Brown","michael.brown33@gmail.com",null,{"$f":"INDEX(B10:D10,1,MIN(IF(ISERROR(SEARCH(\"@\",B10:D10)),\"\",MATCH(COLUMN(B10:D10),COLUMN(B10:D10)))))","v":"michael.brown33@gmail.com"},null,null,null,null,null,null,null,null,"444-555-6666","William Brown","michael.brown33@gmail.com"]
[null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888",null,{"$f":"INDEX(B11:D11,1,MIN(IF(ISERROR(SEARCH(\"@\",B11:D11)),\"\",MATCH(COLUMN(B11:D11),COLUMN(B11:D11)))))","v":"olivia.davis45@gmail.com"},null,null,null,null,null,null,null,null,"Jennifer Clark","olivia.davis45@gmail.com","444-111-8888"]
[null,"Robert Lee","william.brown789@jet.com","Robert Lee",null,{"$f":"INDEX(B12:D12,1,MIN(IF(ISERROR(SEARCH(\"@\",B12:D12)),\"\",MATCH(COLUMN(B12:D12),COLUMN(B12:D12)))))","v":"william.brown789@jet.com"},null,null,null,null,null,null,null,null,"Robert Lee","william.brown789@jet.com","Robert Lee"]

{"sheet":"VBA","index":10,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Applying VBA Code with User Defined Function",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Employee Name, Email Address and Contact Number",null,"Extracted Email Address",null,null,null,null,null,null,null,null,"Employee Name, Email Address and Contact Number",null,"Extracted Email Address"]
[null,"Emily Wilson, emily.wilson@outlook.com",null,{"$f":"Extract_Email_Address(B5)","v":"emily.wilson@outlook.com"},null,null,null,null,null,null,null,null,"Emily Wilson, emily.wilson@outlook.com"]
[null,"Michael Brown, michael.brown33@gmail.com",null,{"$f":"Extract_Email_Address(B6)","v":"michael.brown33@gmail.com"},null,null,null,null,null,null,null,null,"Michael Brown, michael.brown33@gmail.com"]
[null,"Sarah Davis, sarah.davis21@hotmail.com",null,{"$f":"Extract_Email_Address(B7)","v":"sarah.davis21@hotmail.com"},null,null,null,null,null,null,null,null,"Sarah Davis, sarah.davis21@hotmail.com"]
[null,"Robert Lee, robert.lee89@yahoo.com",null,{"$f":"Extract_Email_Address(B8)","v":"robert.lee89@yahoo.com"},null,null,null,null,null,null,null,null,"Robert Lee, robert.lee89@yahoo.com"]
[null,"Jennifer Clark, jennifer.clark29@example.com",null,{"$f":"Extract_Email_Address(B9)","v":"jennifer.clark29@example.com"},null,null,null,null,null,null,null,null,"Jennifer Clark, jennifer.clark29@example.com"]
[null,"William Brown, william.brown789@jet.com",null,{"$f":"Extract_Email_Address(B10)","v":"william.brown789@jet.com"},null,null,null,null,null,null,null,null,"William Brown, william.brown789@jet.com"]
[null,"Andrew Wilson, andrew.wilson1973@outlook.com",null,{"$f":"Extract_Email_Address(B11)","v":"andrew.wilson1973@outlook.com"},null,null,null,null,null,null,null,null,"Andrew Wilson, andrew.wilson1973@outlook.com"]
[null,"Olivia Davis, olivia.davis45@gmail.com",null,{"$f":"Extract_Email_Address(B12)","v":"olivia.davis45@gmail.com"},null,null,null,null,null,null,null,null,"Olivia Davis, olivia.davis45@gmail.com"]

{"sheet":"User Name","index":11,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Extracting User Name from Email Addresses",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Email Address and Contact Number","User Name",null,null,null,null,null,null,null,null,null,"Email Address and Contact Number","User Name"]
[null,"emily.wilson@outlook.com, 777-888-9999","emily.wilson",null,null,null,null,null,null,null,null,null,"emily.wilson@outlook.com, 777-888-9999"]
[null,"michael.brown33@gmail.com, 444-555-6666","michael.brown33",null,null,null,null,null,null,null,null,null,"michael.brown33@gmail.com, 444-555-6666"]
[null,"sarah.davis21@hotmail.com, 222-333-4444","sarah.davis21",null,null,null,null,null,null,null,null,null,"sarah.davis21@hotmail.com, 222-333-4444"]
[null,"robert.lee89@yahoo.com, 111-222-3333","robert.lee89",null,null,null,null,null,null,null,null,null,"robert.lee89@yahoo.com, 111-222-3333"]
[null,"jennifer.clark29@example.com, 888-777-6666","jennifer.clark29",null,null,null,null,null,null,null,null,null,"jennifer.clark29@example.com, 888-777-6666"]
[null,"william.brown789@jet.com, 999-888-7777","william.brown789",null,null,null,null,null,null,null,null,null,"william.brown789@jet.com, 999-888-7777"]
[null,"andrew.wilson1973@outlook.com, 777-222-5555","andrew.wilson1973",null,null,null,null,null,null,null,null,null,"andrew.wilson1973@outlook.com, 777-222-5555"]
[null,"olivia.davis45@gmail.com, 444-111-8888","olivia.davis45",null,null,null,null,null,null,null,null,null,"olivia.davis45@gmail.com, 444-111-8888"]

{"sheet":"Outlook","index":12,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Extracted Email Address"]
[null," emily.wilson@outlook.com"]
[null," michael.brown33@gmail.com"]
[null," sarah.davis21@hotmail.com"]
[null," robert.lee89@yahoo.com"]
[null," jennifer.clark29@example.com"]
[null," william.brown789@jet.com"]
[null," andrew.wilson1973@outlook.com"]
[null," olivia.davis45@gmail.com"]