{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Remove Characters - Examples","Remove character","Remove multiple characters","Remove certain text","Remove Nth character","Remove first char","Remove last char2","Remove chars from left & right","Remove chars from left & ri (2)","Sheet1","Remove text after char","Remove text before char","Remove text after char (4)","Remove text after last","Remove text before nth","Remove tex after nth","Remove after last occurrence","Remove before last occurrence","Remove text after (2)","Remove text after char (2)","Remove first char (3)","Remove first char (2)","Remove last char","Remove chars from right","Remove chars from right (2)","Remove numbers keep text","Remove text keep numbers","Split text and numbers","Remove spaces"],"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":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,3],[17,1,17,2],[18,1,18,2],[19,1,19,2],[5,1,5,2],[8,2,8,3],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[]
[null,"Sample Workbook to Remove Characters in Excel"]
[]
[null,"The workbook shows how to remove characters and text in Excel using formulas and custom user-defined functions."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-07-14"]
[null,"Tutorial URL","How to remove characters and text in Excel"]
[]
[null,"Examples:"]
["• ","Remove certain character from string "]
["• ","Remove multiple characters"]
["• ","Remove certain text"]
["• ","Remove Nth instance of a specific character"]
["• ","Remove characters from left"]
["• ","Remove characters from right"]
["• ","Remove numbers from a text string "]
["• ","Remove text and leave numbers"]
["• ","Remove spaces before and after text "]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Remove character","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["#1001",{"$f":"SUBSTITUTE(A2, \"#\", \"\")","v":"1001"}]
["#1002",{"$f":"SUBSTITUTE(A3, \"#\", \"\")","v":"1002"}]
["#1003/#1003_1","1003/1003_1"]
["#1004","1004"]
["#1005/#1005a/#1005b","1005/1005a/1005b"]

{"sheet":"Remove multiple characters","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["#10/01",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, \"#\",\"\"), \"/\", \"\"), \"\\\", \"\")","v":"1001"}]
["#1002\\AB",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3, \"#\",\"\"), \"/\", \"\"), \"\\\", \"\")","v":"1002AB"}]
["1003#A","1003A"]
["1004/AB\\CD","1004ABCD"]

{"sheet":"Remove certain text","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["mailto:sophia@gmail.com",{"$f":"SUBSTITUTE(A2, \"mailto:\", \"\")","v":"sophia@gmail.com"}]
["mailto:emma@gmail.com",{"$f":"SUBSTITUTE(A3, \"mailto:\", \"\")","v":"emma@gmail.com"}]
["mailto:olivia@gmail.com","olivia@gmail.com"]
["mailto:aiden@gmail.com","aiden@gmail.com"]
["mailto:lucas@gmail.com","lucas@gmail.com"]

{"sheet":"Remove Nth character","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["1001/AB/01/*",{"$f":"SUBSTITUTE(A2, \"/\", \"\", 1)","v":"1001AB/01/*"},"> removes 1st slash"]
["1001/AB/01/*",{"$f":"SUBSTITUTE(A3, \"/\", \"\", 2)","v":"1001/AB01/*"},"> removes 2nd slash"]
["1001/AB/01/*",{"$f":"SUBSTITUTE(A4, \"/\", \"\", 3)","v":"1001/AB/01*"},"> removes 3rd slash"]

{"sheet":"Remove first char","index":5,"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 last char2","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Sophia: sophia@gmail.com",{"$f":"LEFT(A2, SEARCH(\":\", A2) -1)","v":"Sophia"}]
["Emma: emma@gmail.com",{"$f":"LEFT(A3, SEARCH(\":\", A3) -1)","v":"Emma"}]
["Olivia: olivia@gmail.com","Olivia"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"Remove chars from left & right","index":7,"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"]

{"sheet":"Remove chars from left & ri (2)","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Sophia, Sophia@gmail.com","Sophia"]
["Emma, Emma@gmail.com","Emma"]
["Olivia, Olivia@gmail.com","Olivia"]
["Mike, Mike@gmail.com","Mike"]
["Neal, Neal@gmail.com","Neal"]
["Rob, Rob@gmail.com","Rob"]

{"sheet":"Sheet1","index":9,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Sophia","Finance","(101) 123-4567",{"$f":"A2&\", \"&B2","v":"Sophia, Finance"},"Sophia, Finance, (101) 123-4567",null,null,null,"Sophia, Finance"]
["Emma","Design","(102) 123-4568",{"$f":"A3&\", \"&B3","v":"Emma, Design"},"Emma, Design, (102) 123-4568",null,null,null,"Emma, Design"]
["Olivia","Marketing","(103) 123-4569","Olivia, Marketing","Olivia, Marketing, (103) 123-4569",null,null,null,"Olivia, Marketing"]
["Mike","CTO","(104) 123-4570","Mike, CTO","Mike, CTO, (104) 123-4570",null,null,null,"Mike, CTO"]
["Neal","Analysis","(105) 123-4571","Neal, Analysis","Neal, Analysis, (105) 123-4571",null,null,null,"Neal, Analysis"]
["Rob","CEO","(106) 123-4572","Rob, CEO","Rob, CEO, (106) 123-4572",null,null,null,"Rob, CEO"]

{"sheet":"Remove text after char","index":10,"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"}]
["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":"Remove text before char","index":11,"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"}]
["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 after char (4)","index":12,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data"]
["Sophia, Finance"]
["Emma, Design"]
["Olivia, Marketing"]
["Mike, CTO"]
["Neal, Analysis"]
["Rob, CEO"]

{"sheet":"Remove text after last","index":13,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, (102) 123-4568",{"$f":"LEFT(A2, FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", LEN(A2) - LEN(SUBSTITUTE(A2, \",\",\"\")))) -1)","v":"Emma, Design"}]
["Mike, CTO, (104) 123-4570",{"$f":"LEFT(A3, FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", LEN(A3) - LEN(SUBSTITUTE(A3, \",\",\"\")))) -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":"Remove text before nth","index":14,"n_rows":18,"n_cols":15,"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"},{"$f":"RIGHT(SUBSTITUTE(A2, \",\", \"#\", 2), LEN(A2) - FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", 2)))","v":" (102) 123-4568"},{"$f":"TRIM(RIGHT(SUBSTITUTE(A2, \",\", CHAR(9), 2), LEN(A2)- FIND(CHAR(9), SUBSTITUTE(A2, \",\", CHAR(9), 2), 1)))","v":"(102) 123-4568"}]
["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,null,null," "]

{"sheet":"Remove tex after nth","index":15,"n_rows":7,"n_cols":2,"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"}]
["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":"Remove after last occurrence","index":16,"n_rows":7,"n_cols":6,"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"},null,null,null,{"$f":"LEN(B2)","v":22}]
["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":"Remove before last occurrence","index":17,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, Office 2, (102) 123-4568",{"$f":"TRIM(RIGHT(A2, LEN(A2) - 23))","v":"(102) 123-4568"}]
["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":"Remove text after (2)","index":18,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Emma, Design, (102) 123-4568",{"$f":"LEFT(A2, SEARCH(\",\", A2) -1)","v":"Emma"},{"$f":"LEFT(A2, FIND(\"@\", SUBSTITUTE(A2, \",\", \"@\", LEN(A2)-LEN(SUBSTITUTE(A2, \",\",\"\")))) -1)","v":"Emma, Design"},{"$f":"RIGHT(SUBSTITUTE(A2, \",\", \"#\", 2), LEN(A2)- FIND(\"#\", SUBSTITUTE(A2, \",\", \"#\", 2), 1) -1)","v":"(102) 123-4568"},{"$f":"CLEAN(D2)","v":"(102) 123-4568"},null,"West office, (102) 123-4568"]
["Mike, CTO, (104) 123-4570",{"$f":"LEFT(A3, SEARCH(\",\", A3) -1)","v":"Mike"},null,{"$f":"RIGHT(SUBSTITUTE(A3, \",\", \"#\", 2), LEN(A3)- FIND(\"#\", SUBSTITUTE(A3, \",\", \"#\", 2), 1) -1)","v":"(104) 123-4570"}]
["Neal, Analysis, (105) 123-4571","Neal",null,"(105) 123-4571"]
["Olivia, Marketing, (103) 123-4569","Olivia",null,"(103) 123-4569"]
["Rob, CEO, (106) 123-4572","Rob",null,"(106) 123-4572"]
["Sophia, Finance, (101) 123-4567","Sophia",null,"(101) 123-4567"]

{"sheet":"Remove text after char (2)","index":19,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["Sophia, Finance, (101) 123-4567"]
["Emma, Design, (102) 123-4568"]
["Olivia, Marketing, (103) 123-4569"]
["Mike, CTO, (104) 123-4570"]
["Neal, Analysis, (105) 123-4571"]
["Rob, CEO, (106) 123-4572"]

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

{"sheet":"Remove first char (2)","index":21,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["#1",{"$f":"RIGHT(A2, LEN(A2) - 1) *1","v":1}]
["#2",{"$f":"RIGHT(A3, LEN(A3) - 1) *1","v":2}]
["#3",3]
["#4",4]
["#5",5]
["Total",{"$f":"SUM(B2:B6)","v":15}]

{"sheet":"Remove last char","index":22,"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":23,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Original data","Result","Formula"]
["sophia@gmail.com*",{"$f":"LEFT(A2, LEN(A2) - 1)","v":"sophia@gmail.com"}," =LEFT(A2, LEN(A2) - 1)"]
["emma@gmail.com**",{"$f":"LEFT(A3, LEN(A3) - 2)","v":"emma@gmail.com"}," =LEFT(A3, LEN(A3) - 2)"]
["olivia@gmail.com***",{"$f":"LEFT(A4, LEN(A4) - 3)","v":"olivia@gmail.com"}," =LEFT(A4, LEN(A4) - 3)"]

{"sheet":"Remove chars from right (2)","index":24,"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 the 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 the last 3 characters"]

{"sheet":"Remove numbers keep text","index":25,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Original data","Native formula","Custom function"]
["210 Sunset Road",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A2, _xlfn.SEQUENCE(LEN(A2)), 1)+0), MID(A2, _xlfn.SEQUENCE(LEN(A2)), 1), \"\")))","v":"Sunset Road"},{"$f":"TRIM(RemoveNumbers(A2))","v":{"$error":"#NAME?"}}]
["Sunset Road 210",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A3, _xlfn.SEQUENCE(LEN(A3)), 1)+0), MID(A3, _xlfn.SEQUENCE(LEN(A3)), 1), \"\")))","v":"Sunset Road"},{"$f":"RemoveNumbers(A3)","v":{"$error":"#NAME?"}}]
["Sunset 210 Road",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A4, _xlfn.SEQUENCE(LEN(A4)), 1)+0), MID(A4, _xlfn.SEQUENCE(LEN(A4)), 1), \"\")))","v":"Sunset Road"},{"$f":"RemoveNumbers(A4)","v":{"$error":"#NAME?"}}]
["1A2B3C4D",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A5, _xlfn.SEQUENCE(LEN(A5)), 1)+0), MID(A5, _xlfn.SEQUENCE(LEN(A5)), 1), \"\")))","v":"ABCD"},{"$f":"RemoveNumbers(A5)","v":{"$error":"#NAME?"}}]
["AA-105-BC",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A6, _xlfn.SEQUENCE(LEN(A6)), 1)+0), MID(A6, _xlfn.SEQUENCE(LEN(A6)), 1), \"\")))","v":"AA--BC"},{"$f":"RemoveNumbers(A6)","v":{"$error":"#NAME?"}}]
["AA/1/BC/23",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A7, _xlfn.SEQUENCE(LEN(A7)), 1)+0), MID(A7, _xlfn.SEQUENCE(LEN(A7)), 1), \"\")))","v":"AA//BC/"},{"$f":"RemoveNumbers(A7)","v":{"$error":"#NAME?"}}]
["No numbers in this cell",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(A8, _xlfn.SEQUENCE(LEN(A8)), 1)+0), MID(A8, _xlfn.SEQUENCE(LEN(A8)), 1), \"\")))","v":"No numbers in this cell"},{"$f":"RemoveNumbers(A8)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Remove text keep numbers","index":26,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Original data","Native formula","Custom function"]
["210 Sunset Road",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A2, _xlfn.SEQUENCE(LEN(A2)), 1) + 0, \"\"))","v":"210"},{"$f":"RemoveText(A2)","v":{"$error":"#NAME?"}}]
["Sunset Road 210",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A3, _xlfn.SEQUENCE(LEN(A3)), 1) + 0, \"\"))","v":"210"},{"$f":"RemoveText(A3)","v":{"$error":"#NAME?"}}]
["Sunset 210 Road",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A4, _xlfn.SEQUENCE(LEN(A4)), 1) + 0, \"\"))","v":"210"},{"$f":"RemoveText(A4)","v":{"$error":"#NAME?"}}]
["1A2B3C4D",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A5, _xlfn.SEQUENCE(LEN(A5)), 1) + 0, \"\"))","v":"1234"},{"$f":"RemoveText(A5)","v":{"$error":"#NAME?"}}]
["AA-105-BC",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A6, _xlfn.SEQUENCE(LEN(A6)), 1) + 0, \"\"))","v":"105"},{"$f":"RemoveText(A6)","v":{"$error":"#NAME?"}}]
["AA/1/BC/23",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A7, _xlfn.SEQUENCE(LEN(A7)), 1) + 0, \"\"))","v":"123"},{"$f":"RemoveText(A7)","v":{"$error":"#NAME?"}}]
["No numbers in this cell",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A8, _xlfn.SEQUENCE(LEN(A8)), 1) + 0, \"\"))","v":""},{"$f":"RemoveText(A8)","v":{"$error":"#NAME?"}}]

{"sheet":"Split text and numbers","index":27,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Original data","Numbers","Text"]
["210 Sunset Road",{"$f":"SplitTextNumbers(A2, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A2, 0)","v":{"$error":"#NAME?"}}]
["Sunset Road 210",{"$f":"SplitTextNumbers(A3, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A3, 0)","v":{"$error":"#NAME?"}}]
["Sunset 210 Road",{"$f":"SplitTextNumbers(A4, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A4, 0)","v":{"$error":"#NAME?"}}]
["1A2B3C4D",{"$f":"SplitTextNumbers(A5, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A5, 0)","v":{"$error":"#NAME?"}}]
["AA-105-BC",{"$f":"SplitTextNumbers(A6, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A6, 0)","v":{"$error":"#NAME?"}}]
["AA/1/BC/23",{"$f":"SplitTextNumbers(A7, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A7, 0)","v":{"$error":"#NAME?"}}]
["No numbers in this cell",{"$f":"SplitTextNumbers(A8, 1)","v":{"$error":"#NAME?"}},{"$f":"SplitTextNumbers(A8, 0)","v":{"$error":"#NAME?"}}]

{"sheet":"Remove spaces","index":28,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Original data","Result"]
["  #1001",{"$f":"TRIM(A2)","v":"#1001"}]
["#1002      / #1002a",{"$f":"TRIM(A3)","v":"#1002 / #1002a"}]
["      #1003/      #1003-1","#1003/ #1003-1"]
[null,""]