{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Split Text & Numbers - Examples","Remove numbers keep text","Remove text keep numbers","Split text and numbers"],"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":"Split Text & Numbers - Examples","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,4],[11,1,11,2],[12,1,12,2],[5,1,5,2],[8,2,8,3],[13,1,13,2]]}
[]
[]
[]
[null,"Sample Workbook to Remove Text or Numbers in Excel"]
[]
[null,"The workbook shows how to remove numbers from a string in Excel or strip text characters keeping numeric ones."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-07-16"]
[null,"Tutorial URL","How to remove text or numbers from Excel cells"]
[]
[null,"Examples:"]
["• ","Remove text and leave numbers"]
["• ","Remove spaces before and after text "]
["• ","Split text and numbers into separate columns"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Remove numbers keep text","index":1,"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":"Sunset Road"}]
["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":"TRIM(RemoveNumbers(A3))","v":"Sunset Road"}]
["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":"TRIM(RemoveNumbers(A4))","v":"Sunset Road"}]
["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":"TRIM(RemoveNumbers(A5))","v":"ABCD"}]
["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":"TRIM(RemoveNumbers(A6))","v":"AA--BC"}]
["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":"TRIM(RemoveNumbers(A7))","v":"AA//BC/"}]
["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":"TRIM(RemoveNumbers(A8))","v":"No numbers in this cell"}]
[]
[]
[]
[]
[]
[]
[null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Remove text keep numbers","index":2,"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":"210"}]
["Sunset Road 210",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A3, _xlfn.SEQUENCE(LEN(A3)), 1) + 0, \"\"))","v":"210"},{"$f":"RemoveText(A3)","v":"210"}]
["Sunset 210 Road",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A4, _xlfn.SEQUENCE(LEN(A4)), 1) + 0, \"\"))","v":"210"},{"$f":"RemoveText(A4)","v":"210"}]
["1A2B3C4D",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A5, _xlfn.SEQUENCE(LEN(A5)), 1) + 0, \"\"))","v":"1234"},{"$f":"RemoveText(A5)","v":"1234"}]
["AA-105-BC",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A6, _xlfn.SEQUENCE(LEN(A6)), 1) + 0, \"\"))","v":"105"},{"$f":"RemoveText(A6)","v":"105"}]
["AA/1/BC/23",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A7, _xlfn.SEQUENCE(LEN(A7)), 1) + 0, \"\"))","v":"123"},{"$f":"RemoveText(A7)","v":"123"}]
["No numbers in this cell",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(A8, _xlfn.SEQUENCE(LEN(A8)), 1) + 0, \"\"))","v":""},{"$f":"RemoveText(A8)","v":""}]

{"sheet":"Split text and numbers","index":3,"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":"210"},{"$f":"TRIM(SplitTextNumbers(A2, 0))","v":"Sunset Road"}]
["Sunset Road 210",{"$f":"SplitTextNumbers(A3, 1)","v":"210"},{"$f":"SplitTextNumbers(A3, 0)","v":"Sunset Road "}]
["Sunset 210 Road",{"$f":"SplitTextNumbers(A4, 1)","v":"210"},{"$f":"SplitTextNumbers(A4, 0)","v":"Sunset  Road"}]
["1A2B3C4D",{"$f":"SplitTextNumbers(A5, 1)","v":"1234"},{"$f":"SplitTextNumbers(A5, 0)","v":"ABCD"}]
["AA-105-BC",{"$f":"SplitTextNumbers(A6, 1)","v":"105"},{"$f":"SplitTextNumbers(A6, 0)","v":"AA--BC"}]
["AA/1/BC/23",{"$f":"SplitTextNumbers(A7, 1)","v":"123"},{"$f":"SplitTextNumbers(A7, 0)","v":"AA//BC/"}]
["No numbers in this cell",{"$f":"SplitTextNumbers(A8, 1)","v":""},{"$f":"SplitTextNumbers(A8, 0)","v":"No numbers in this cell"}]