Strip non-numeric characters from Excel column

Strip non-numeric characters from Excel column

Summary 

To remove non-numeric characters from a text string, you can use a formula based on the the TEXTJOIN function. In the example shown, the formula in C5 is:

=TEXTJOIN("",TRUE,IFERROR(MID(B5,ROW(INDIRECT("1:100")),1)+0,""))
Then would suggest you copy the column and paste values to a new column, and delete the first two.

    • Related Articles

    • Searching emails in Outlook

      How to search in Outlook Outlook’s search box is a powerful tool to help you find messages, contacts, tasks, and calendar entries.  You can type a number of phrases in the Search box at the top of the Outlook window. In addition to searching for ...