{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Find & Replace","Find & Replace last part","Text to Column","Left","Right","Mid","Text before hyphen","Text after hyphen ","Text between hyphen","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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Extracting Text From a Cell "]
[]
[null,"Text","Extracted Text"]
[null,"P003-116-001"]
[null,"P003-117-001"]
[null,"P003-118-001"]
[null,"P003-119-001"]

{"sheet":"Find & Replace","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"john@gmail.com","john",null,null,"john@gmail.com"]
[null,"kit@yahoo.com","kit",null,null,"kit@yahoo.com"]
[null,"mary@hotmail.com","mary",null,null,"mary@hotmail.com"]
[null,"curie@gmail.com","curie",null,null,"curie@gmail.com"]

{"sheet":"Find & Replace last part","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"john@gmail.com","gmail.com",null,null,"john@gmail.com"]
[null,"kit@yahoo.com","yahoo.com",null,null,"kit@yahoo.com"]
[null,"mary@hotmail.com","hotmail.com",null,null,"mary@hotmail.com"]
[null,"curie@gmail.com","gmail.com",null,null,"curie@gmail.com"]

{"sheet":"Text to Column","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,2,4,3],[2,1,2,3],[2,6,2,8],[4,7,4,8]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,null,"Text","Extracted Text"]
[null,"john@gmail.com","john","gmail.com",null,null,"john@gmail.com","john","gmail.com"]
[null,"kit@yahoo.com","kit","yahoo.com",null,null,"kit@yahoo.com","kit","yahoo.com"]
[null,"mary@hotmail.com","mary","hotmail.com",null,null,"mary@hotmail.com","mary","hotmail.com"]
[null,"curie@gmail.com","curie","gmail.com",null,null,"curie@gmail.com","curie","gmail.com"]

{"sheet":"Left","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"LEFT(B6,4)","v":"P003"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"LEFT(B7,4)","v":"P003"},null,null,"P003-117-001"]
[null,"P003-118-001","P003",null,null,"P003-118-001"]
[null,"P003-119-001","P003",null,null,"P003-119-001"]

{"sheet":"Right","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"RIGHT(B6,3)","v":"001"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"RIGHT(B7,3)","v":"001"},null,null,"P003-117-001"]
[null,"P003-118-001","001",null,null,"P003-118-001"]
[null,"P003-119-001","001",null,null,"P003-119-001"]

{"sheet":"Mid","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"MID(B6,6,3)","v":"116"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"MID(B7,6,3)","v":"117"},null,null,"P003-117-001"]
[null,"P003-118-001","118",null,null,"P003-118-001"]
[null,"P003-119-001","119",null,null,"P003-119-001"]

{"sheet":"Text before hyphen","index":7,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"LEFT(B6,SEARCH(\"-\",B6)-1)","v":"P003"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"LEFT(B7,SEARCH(\"-\",B7)-1)","v":"P003"},null,null,"P003-117-001"]
[null,"P003-118-001","P003",null,null,"P003-118-001"]
[null,"P003-119-001","P003",null,null,"P003-119-001"]

{"sheet":"Text after hyphen ","index":8,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\"-\",B6))","v":"116-001"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"RIGHT(B7,LEN(B7)-SEARCH(\"-\",B7))","v":"117-001"},null,null,"P003-117-001"]
[null,"P003-118-001","118-001",null,null,"P003-118-001"]
[null,"P003-119-001","119-001",null,null,"P003-119-001"]

{"sheet":"Text between hyphen","index":9,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"P003-116-001",{"$f":"MID(B6,SEARCH(\"-\",B6)+1,SEARCH(\"-\",B6,SEARCH(\"-\",B6)+1)-SEARCH(\"-\",B6)-1)","v":"116"},null,null,"P003-116-001"]
[null,"P003-117-001",{"$f":"MID(B7,SEARCH(\"-\",B7)+1,SEARCH(\"-\",B7,SEARCH(\"-\",B7)+1)-SEARCH(\"-\",B7)-1)","v":"117"},null,null,"P003-117-001"]
[null,"P003-118-001","118",null,null,"P003-118-001"]
[null,"P003-119-001","119",null,null,"P003-119-001"]

{"sheet":"VBA","index":10,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Extracting Text From a Cell ",null,null,null,"Try Yourself"]
[]
[null,"Text","Extracted Text",null,null,"Text","Extracted Text"]
[null,"May the force be with you",{"$f":"ExtrText(B6,3)","v":"force"},null,null,"May the force be with you"]
[null,"God bless you",{"$f":"ExtrText(B7,3)","v":"you"},null,null,"God bless you"]
[null,"You need water ",{"$f":"ExtrText(B8,3)","v":"water"},null,null,"You need water "]
[null,"Go there and play",{"$f":"ExtrText(B9,3)","v":"and"},null,null,"Go there and play"]