{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Remove Characters - Examples","Remove text after char","Remove text before char","After nth instance","Before nth instance","After last occurence","Before last occurrence","Custom fucntion"],"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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,3,3],[17,1,17,2],[5,1,5,2],[8,2,8,3],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2]]}
[]
[]
[]
[null,"Remove Text Before or After a Certain Character"]
[]
[null,"The workbook shows how to delete everything before or after a specific character with native and custom functions."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-07-29"]
[null,"Tutorial URL","Remove text before, after or between two characters in Excel"]
[]
[null,"Examples:"]
["• ","Remove everything after a specific character"]
["• ","Remove everything before a specific character"]
["• ","Delete text after Nth occurrence of a character"]
["• ","Delete text before Nth occurrence of a character"]
["• ","Strip text after the last occurrence of a character"]
["• ","Strip text before the last occurrence of a character"]
["• ","Custom function to remove text on either side of a character"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Remove text after char","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Sophia, Finance",{"$f":"LEFT(A2, SEARCH(\",\", A2) -1)","v":"Sophia"},">> remove text after the comma"]
["Emma, Design",{"$f":"LEFT(A3, SEARCH(\",\", A3) -1)","v":"Emma"}]
["Olivia, Marketing","Olivia"]
["Mike, CTO","Mike"]
["Neal, Analysis","Neal"]
["Rob, CEO","Rob"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Remove text before char","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Sophia, Finance",{"$f":"TRIM(RIGHT(A2, LEN(A2) - SEARCH(\",\", A2)))","v":"Finance"},">> remove text before the comma"]
["Emma, Design",{"$f":"TRIM(RIGHT(A3, LEN(A3) - SEARCH(\",\", A3)))","v":"Design"}]
["Olivia, Marketing","Marketing"]
["Mike, CTO","CTO"]
["Neal, Analysis","Analysis"]
["Rob, CEO","CEO"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"After nth instance","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, (102) 123-4568",{"$f":"LEFT(A2, FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", 2)) -1)","v":"Emma, Design"},">> remove text after 2nd comma"]
["Mike, CTO, (104) 123-4570",{"$f":"LEFT(A3, FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", 2)) -1)","v":"Mike, CTO"}]
["Neal, Analysis, (105) 123-4571","Neal, Analysis"]
["Olivia, Marketing, (103) 123-4569","Olivia, Marketing"]
["Rob, CEO, (106) 123-4572","Rob, CEO"]
["Sophia, Finance, (101) 123-4567","Sophia, Finance"]

{"sheet":"Before nth instance","index":4,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, (102) 123-4568",{"$f":"TRIM(RIGHT(SUBSTITUTE(A2, \",\", \"#\", 2), LEN(A2) - FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", 2))))","v":"(102) 123-4568"},">> remove text before 2nd comma"]
["Mike, CTO, (104) 123-4570",{"$f":"TRIM(RIGHT(SUBSTITUTE(A3, \",\", \"#\", 2), LEN(A3) - FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", 2))))","v":"(104) 123-4570"}]
["Neal, Analysis, (105) 123-4571","(105) 123-4571"]
["Olivia, Marketing, (103) 123-4569","(103) 123-4569"]
["Rob, CEO, (106) 123-4572","(106) 123-4572"]
["Sophia, Finance, (101) 123-4567","(101) 123-4567"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"After last occurence","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, Office 2, (102) 123-4568",{"$f":"LEFT(A2, FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", LEN(A2) - LEN(SUBSTITUTE(A2, \",\",\"\")))) -1)","v":"Emma, Design, Office 2"},">> remove text after the last comma"]
["Mike, CTO, Head Office, (104) 123-4570",{"$f":"LEFT(A3, FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", LEN(A3) - LEN(SUBSTITUTE(A3, \",\",\"\")))) -1)","v":"Mike, CTO, Head Office"}]
["Neal, Analysis, (105) 123-4571","Neal, Analysis"]
["Olivia, Marketing,  Office 2, (103) 123-4569","Olivia, Marketing,  Office 2"]
["Rob, CEO, (106) 123-4572","Rob, CEO"]
["Sophia, Finance, Office 1, (101) 123-4567","Sophia, Finance, Office 1"]

{"sheet":"Before last occurrence","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, Office 2, (102) 123-4568",{"$f":"TRIM(RIGHT(A2, LEN(A2) - FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", LEN(A2) - LEN(SUBSTITUTE(A2, \",\",\"\"))))))","v":"(102) 123-4568"},">> remove text before the last comma"]
["Mike, CTO, Head Office, (104) 123-4570",{"$f":"TRIM(RIGHT(A3, LEN(A3) - FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", LEN(A3) - LEN(SUBSTITUTE(A3, \",\",\"\"))))))","v":"(104) 123-4570"}]
["Neal, Analysis, (105) 123-4571","(105) 123-4571"]
["Olivia, Marketing,  Office 2, (103) 123-4569","(103) 123-4569"]
["Rob, CEO, (106) 123-4572","(106) 123-4572"]
["Sophia, Finance, Office 1, (101) 123-4567","(101) 123-4567"]

{"sheet":"Custom fucntion","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Remove text"]
["Original data","After 1st comma","Before 1st comma"]
["Emma, Design, Office 2, (102) 123-4568",{"$f":"RemoveText(A3, \", \", 1, TRUE)","v":"Emma"},{"$f":"RemoveText(A3, \", \", 1, FALSE)","v":"Design, Office 2, (102) 123-4568"}]
["Mike, CTO, Head Office, (104) 123-4570",{"$f":"RemoveText(A4, \", \", 1, TRUE)","v":"Mike"},{"$f":"RemoveText(A4, \", \", 1, FALSE)","v":"CTO, Head Office, (104) 123-4570"}]
["Neal, Analysis, (105) 123-4571",{"$f":"RemoveText(A5, \", \", 1, TRUE)","v":"Neal"},{"$f":"RemoveText(A5, \", \", 1, FALSE)","v":"Analysis, (105) 123-4571"}]
["Olivia, Marketing,  Office 2, (103) 123-4569",{"$f":"RemoveText(A6, \", \", 1, TRUE)","v":"Olivia"},{"$f":"RemoveText(A6, \", \", 1, FALSE)","v":"Marketing,  Office 2, (103) 123-4569"}]
["Rob, CEO, (106) 123-4572",{"$f":"RemoveText(A7, \", \", 1, TRUE)","v":"Rob"},{"$f":"RemoveText(A7, \", \", 1, FALSE)","v":"CEO, (106) 123-4572"}]
["Sophia, Finance, Office 1, (101) 123-4567",{"$f":"RemoveText(A8, \", \", 1, TRUE)","v":"Sophia"},{"$f":"RemoveText(A8, \", \", 1, FALSE)","v":"Finance, Office 1, (101) 123-4567"}]