{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Replace","RIGHT","MID","SUBSTITUTE","Text to columns","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":"Replace","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using REPLACE Function"]
[]
[null,"Text","Num_Characters","Result"]
[null,"1Hello",1,{"$f":"REPLACE(B5,1,C5,\"\")","v":"Hello"}]
[null,"12Everyone",2,{"$f":"REPLACE(B6,1,C6,\"\")","v":"Everyone"}]
[null,"123Welcome",3,"Welcome"]
[null,"!234to",4,"to"]
[null,"12345Excel",5,{"$f":"REPLACE(B9,1,C9,\"\")","v":"Excel"}]

{"sheet":"RIGHT","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RIGHT and LEN Function"]
[]
[null,"Text","Num_Characters","Result"]
[null,"1Hello",1,{"$f":"RIGHT(B5,LEN(B5)-C5)","v":"Hello"}]
[null,"12Everyone",2,{"$f":"RIGHT(B6,LEN(B6)-C6)","v":"Everyone"}]
[null,"123Welcome",3,"Welcome"]
[null,"!234to",4,"to"]
[null,"12345Excel",5,"Excel"]

{"sheet":"MID","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using MID and LEN Function"]
[]
[null,"Text","Num_Characters","Result"]
[null,"1Hello",1,{"$f":"MID(B5,1+C5,LEN(B5))","v":"Hello"}]
[null,"12Everyone",2,{"$f":"MID(B6,1+C6,LEN(B6))","v":"Everyone"}]
[null,"123Welcome",3,"Welcome"]
[null,"!234to",4,"to"]
[null,"12345Excel",5,"Excel"]

{"sheet":"SUBSTITUTE","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using SUBSTITUTE Function"]
[]
[null,"Text","Num_Characters","Result"]
[null,"1Hello",1,{"$f":"SUBSTITUTE(B5,LEFT(B5,C5),\"\")","v":"Hello"}]
[null,"12Everyone",2,{"$f":"SUBSTITUTE(B6,LEFT(B6,C6),\"\")","v":"Everyone"}]
[null,"123Welcome",3,"Welcome"]
[null,"!234to",4,"to"]
[null,"12345Excel",5,"Excel"]

{"sheet":"Text to columns","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ID"]
[null,"K",1123]
[null,"H",6638]
[null,"L",8859]
[null,"X",94]
[null,"H",6970]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA"]
[]
[null,"Text","Num_Characters","Result"]
[null,"1Hello",1,{"$f":"RemoveLeft(B5,C5)","v":"Hello"}]
[null,"12Everyone",2,{"$f":"RemoveLeft(B6,C6)","v":"Everyone"}]
[null,"123Welcome",3,{"$f":"RemoveLeft(B7,C7)","v":"Welcome"}]
[null,"!234to",4,"to"]
[null,"12345Excel",5,"Excel"]