{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Find & Replace","SUBSTITUTE","Par. Instance","Nested SUB.","First Letters","Last Letters","First and Last","Array","VBA F.","VBA L.","VBA All","TextToCol","Flash Fill"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Find & Replace"]
[]
[null,"Name","Code"]
[null,"Kevin",101]
[null,"Owens",102]
[null,"Shawn",103]
[null,"Michael",104]
[null,"Steve",105]
[null,"Austin",106]

{"sheet":"SUBSTITUTE","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"SUBSTITUTE(C5,\"WWE\",\"\")","v":"101"}]
[null,"Owens","WWE102",{"$f":"SUBSTITUTE(C6,\"WWE\",\"\")","v":"102"}]
[null,"Shawn","WWE103","103"]
[null,"Michael","WWE104","104"]
[null,"Steve","WWE105","105"]
[null,"Austin","WWE106","106"]

{"sheet":"Par. Instance","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"SUBSTITUTE(C5,\"WE\",\"\",1)","v":"W101"}]
[null,"Owens","WWE102",{"$f":"SUBSTITUTE(C6,\"WE\",\"\",1)","v":"W102"}]
[null,"Shawn","WWE103","W103"]
[null,"Michael","WWE104","W104"]
[null,"Steve","WWE105","W105"]
[null,"Austin","WWE106","W106"]

{"sheet":"Nested SUB.","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"SUBSTITUTE(SUBSTITUTE(C5,\"W\",\"\"),\"E\",\"\")","v":"101"}]
[null,"Owens","WWE102",{"$f":"SUBSTITUTE(SUBSTITUTE(C6,\"W\",\"\"),\"E\",\"\")","v":"102"}]
[null,"Shawn","WWE103","103"]
[null,"Michael","WWE104","104"]
[null,"Steve","WWE105","105"]
[null,"Austin","WWE106","106"]

{"sheet":"First Letters","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"RIGHT(C5, LEN(C5)-3)","v":"101"}]
[null,"Owens","WWE102",{"$f":"RIGHT(C6, LEN(C6)-3)","v":"102"}]
[null,"Shawn","WWE103","103"]
[null,"Michael","WWE104","104"]
[null,"Steve","WWE105","105"]
[null,"Austin","WWE106","106"]

{"sheet":"Last Letters","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"LEFT(C5, LEN(C5)-2)","v":"WWE1"}]
[null,"Owens","WWE201",{"$f":"LEFT(C6, LEN(C6)-2)","v":"WWE2"}]
[null,"Shawn","WWE301","WWE3"]
[null,"Michael","WWE401","WWE4"]
[null,"Steve","WWE501","WWE5"]
[null,"Austin","WWE601","WWE6"]

{"sheet":"First and Last","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"MID(C5,3,LEN(C5)-4)","v":"E1"}]
[null,"Owens","WWE201",{"$f":"MID(C6,3,LEN(C6)-4)","v":"E2"}]
[null,"Shawn","WWE301","E3"]
[null,"Michael","WWE401","E4"]
[null,"Steve","WWE501","E5"]
[null,"Austin","WWE601","E6"]

{"sheet":"Array","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"SUM(MID(0&C5,LARGE(INDEX(ISNUMBER(--MID(C5,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":101}]
[null,"Owens","WWE201",{"$f":"SUM(MID(0&C6,LARGE(INDEX(ISNUMBER(--MID(C6,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":201}]
[null,"Shawn","WWE301",{"$f":"SUM(MID(0&C7,LARGE(INDEX(ISNUMBER(--MID(C7,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":301}]
[null,"Michael","WWE401",{"$f":"SUM(MID(0&C8,LARGE(INDEX(ISNUMBER(--MID(C8,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":401}]
[null,"Steve","WWE501",{"$f":"SUM(MID(0&C9,LARGE(INDEX(ISNUMBER(--MID(C9,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":501}]
[null,"Austin","WWE601",{"$f":"SUM(MID(0&C10,LARGE(INDEX(ISNUMBER(--MID(C10,ROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,1)*10^ROW($1:$99)/10)","v":601}]

{"sheet":"VBA F.","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"DeleteFirstL(C5,3)","v":"101"}]
[null,"Owens","WWE201",{"$f":"DeleteFirstL(C6,3)","v":"201"}]
[null,"Shawn","WWE301","301"]
[null,"Michael","WWE401","401"]
[null,"Steve","WWE501","501"]
[null,"Austin","WWE601","601"]

{"sheet":"VBA L.","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"DeleteLastL(C5,2)","v":"WWE1"}]
[null,"Owens","WWE201",{"$f":"DeleteLastL(C6,2)","v":"WWE2"}]
[null,"Shawn","WWE301","WWE3"]
[null,"Michael","WWE401","WWE4"]
[null,"Steve","WWE501","WWE5"]
[null,"Austin","WWE601","WWE6"]

{"sheet":"VBA All","index":10,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",{"$f":"DeleteLetter(C5)","v":"101"}]
[null,"Owens","WWE201",{"$f":"DeleteLetter(C6)","v":"201"}]
[null,"Shawn","WWE301","301"]
[null,"Michael","WWE401","401"]
[null,"Steve","WWE501","501"]
[null,"Austin","WWE601","601"]

{"sheet":"TextToCol","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code"]
[null,"Kevin","WWE",101]
[null,"Owens","WWE",201]
[null,"Shawn","WWE",301]
[null,"Michael","WWE",401]
[null,"Steve","WWE",501]
[null,"Austin","WWE",601]

{"sheet":"Flash Fill","index":12,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Letters from Cell"]
[]
[null,"Name","Code","New Code"]
[null,"Kevin","WWE101",101]
[null,"Owens","WWE201",201]
[null,"Shawn","WWE301",301]
[null,"Michael","WWE401",401]
[null,"Steve","WWE501",501]
[null,"Austin","WWE601",601]