{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Find & Replace","SUBSTITUTE","SUB. Multiple Ch.","LEFT","MID","RIGHT","REPLACE","Flash Fill","VBA"],"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":"Find & Replace","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Remove Specific Text"]
[]
[null,"IDs"]
[null,"liam@google.com",null,"Google.com","liam@google.com"]
[null,"olivia@youtube.com",null,"Youtube.com","olivia@youtube.com"]
[null,"noah@facebook.com",null,"Facebook.com","noah@facebook.com"]
[null,"emma@amazon.com",null,"Amazon.com","emma@amazon.com"]
[null,"oliver@yahoo.com",null,"Yahoo.com","oliver@yahoo.com"]

{"sheet":"SUBSTITUTE","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Top Sites in USA","Company"]
[null,"Google.com",{"$f":"SUBSTITUTE(B5,\".com\",\"\")","v":"Google"}]
[null,"Youtube.com",{"$f":"SUBSTITUTE(B6,\".com\",\"\")","v":"Youtube"}]
[null,"Facebook.com","Facebook"]
[null,"Amazon.com","Amazon"]
[null,"Yahoo.com","Yahoo"]

{"sheet":"SUB. Multiple Ch.","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Data","Output"]
[null,"#244/647@5422",{"$f":"SUBSTITUTE(SUBSTITUTE(\nSUBSTITUTE(B5,\"#\",\"(\"),\"/\",\") \"),\"@\",\"-\")","v":"(244) 647-5422"},null,"#244/647@5422"]
[null,"#244/647@5495",{"$f":"SUBSTITUTE(SUBSTITUTE(\nSUBSTITUTE(B6,\"#\",\"(\"),\"/\",\") \"),\"@\",\"-\")","v":"(244) 647-5495"},null,"#244/647@5495"]
[null,"#244/647@5519","(244) 647-5519",null,"#244/647@5519"]
[null,"#244/647@5542","(244) 647-5542",null,"#244/647@5542"]
[null,"#244/647@5656","(244) 647-5656",null,"#244/647@5656"]

{"sheet":"LEFT","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Top Sites in USA","Company"]
[null,"Google.com",{"$f":"LEFT(B5,FIND(\".\",B5)-1)","v":"Google"}]
[null,"Youtube.com",{"$f":"LEFT(B6,FIND(\".\",B6)-1)","v":"Youtube"}]
[null,"Facebook.com","Facebook"]
[null,"Amazon.com","Amazon"]
[null,"Yahoo.com","Yahoo"]

{"sheet":"MID","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Top Sites in USA","Company"]
[null,"Google.com",{"$f":"MID(B5,1,FIND(\".\",B5,1)-1)","v":"Google"}]
[null,"Youtube.com",{"$f":"MID(B6,1,FIND(\".\",B6,1)-1)","v":"Youtube"}]
[null,"Facebook.com","Facebook"]
[null,"Amazon.com","Amazon"]
[null,"Yahoo.com","Yahoo"]

{"sheet":"RIGHT","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"IDs","Sites"]
[null,"liam@google.com",{"$f":"RIGHT(B5,LEN(B5)\n-FIND(\"@\",B5))","v":"google.com"}]
[null,"olivia@youtube.com",{"$f":"RIGHT(B6,LEN(B6)\n-FIND(\"@\",B6))","v":"youtube.com"}]
[null,"noah@facebook.com","facebook.com"]
[null,"emma@amazon.com","amazon.com"]
[null,"oliver@yahoo.com","yahoo.com"]

{"sheet":"REPLACE","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Names & Titles","Full Names"]
[null,"Dr. Bill Ayers",{"$f":"REPLACE(B5,1,4,\"\")","v":"Bill Ayers"}]
[null,"Dr. Carol Dweck",{"$f":"REPLACE(B6,1,4,\"\")","v":"Carol Dweck"}]
[null,"Dr. Craig Walker","Craig Walker"]
[null,"Dr. Fiona Stanly","Fiona Stanly"]
[null,"Dr. Geoff Gallop","Geoff Gallop"]

{"sheet":"Flash Fill","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Specific Text"]
[]
[null,"Names & Titles","Names"]
[null,"Dr. Bill Ayers","Bill Ayers"]
[null,"Dr. Carol Dweck","Carol Dweck"]
[null,"Dr. Craig Walker","Craig Walker"]
[null,"Dr. Fiona Stanly","Fiona Stanly"]
[null,"Dr. Geoff Gallop","Geoff Gallop"]

{"sheet":"VBA","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Remove Specific Text"]
[]
[null,"Full Names"]
[null,"Bill Ayers",null,"Dr. Bill Ayers"]
[null,"Carol Dweck",null,"Dr. Carol Dweck"]
[null,"Craig Walker",null,"Dr. Craig Walker"]
[null,"Fiona Stanly",null,"Dr. Fiona Stanly"]
[null,"Geoff Gallop",null,"Dr. Geoff Gallop"]