{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Remove Characters - Examples","Remove first char","Remove chars from left","Remove last char","Remove chars from right","Remove chars from left & right"],"not_rendered":{"charts":0,"images":4,"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":"Remove Characters - Examples","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,2],[15,1,15,2],[5,1,5,2],[11,1,11,2],[13,1,13,2]]}
[]
[]
[]
[null,"Remove Left or Right Characters in Excel"]
[]
[null,"The workbook shows how to remove characters from the left or right side of a text string in Excel."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-07-22"]
[null,"Tutorial URL","How to remove characters from left or right in Excel"]
[]
[null,"Examples:"]
["• ","Remove the first character"]
["• ","Remove n characters from left"]
["• ","Remove the last character"]
["• ","Remove n characters from right"]
["• ","Remove characters from both sides"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Remove first char","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["*sophia@gmail.com",{"$f":"REPLACE(A2, 1, 1, \"\")","v":"sophia@gmail.com"}]
["^emma@gmail.com",{"$f":"REPLACE(A3, 1, 1, \"\")","v":"emma@gmail.com"}]
["%olivia@gmail.com","olivia@gmail.com"]

{"sheet":"Remove chars from left","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Native formula","Custom function"]
["*sophia@gmail.com",{"$f":"REPLACE(A2, 1, 1, \"\")","v":"sophia@gmail.com"},{"$f":"RemoveFirstChars(A2, 1)","v":"sophia@gmail.com"},"> removes 1st character"]
["**emma@gmail.com",{"$f":"REPLACE(A3, 1, 2, \"\")","v":"emma@gmail.com"},{"$f":"RemoveFirstChars(A3, 2)","v":"emma@gmail.com"},"> removes first 2 characters"]
["***olivia@gmail.com",{"$f":"REPLACE(A4, 1, 3, \"\")","v":"olivia@gmail.com"},{"$f":"RemoveFirstChars(A4, 3)","v":"olivia@gmail.com"},"> removes first 3 characters"]

{"sheet":"Remove last char","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["sophia@gmail.com*",{"$f":"LEFT(A2, LEN(A2) - 1)","v":"sophia@gmail.com"}]
["emma@gmail.com/",{"$f":"LEFT(A3, LEN(A3) - 1)","v":"emma@gmail.com"}]
["olivia@gmail.com^","olivia@gmail.com"]

{"sheet":"Remove chars from right","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Native formula","Custom function"]
["sophia@gmail.com*",{"$f":"LEFT(A2, LEN(A2) - 1)","v":"sophia@gmail.com"},{"$f":"RemoveLastChars(A2, 1)","v":"sophia@gmail.com"},"> removes last character"]
["emma@gmail.com**",{"$f":"LEFT(A3, LEN(A3) - 2)","v":"emma@gmail.com"},{"$f":"RemoveLastChars(A3, 2)","v":"emma@gmail.com"},"> removes last 2 characters"]
["olivia@gmail.com***",{"$f":"LEFT(A4, LEN(A4) - 3)","v":"olivia@gmail.com"},{"$f":"RemoveLastChars(A4, 3)","v":"olivia@gmail.com"},"> removes last 3 characters"]

{"sheet":"Remove chars from left & right","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["mailto:Sophia@gmail.com",{"$f":"MID(A2, 7+1, LEN(A2) - (7+10))","v":"Sophia"}]
["mailto:Emma@gmail.com",{"$f":"MID(A3, 7+1, LEN(A3) -(7+10))","v":"Emma"}]
["mailto:Olivia@gmail.com","Olivia"]