To remove non-numeric characters from a text string, you can try this experimental formula based on the Table structure with cells containing text and numbers.
To strip characters from the left, you can use a formula based on the RIGHT and REPLACE function changes a specific part of a text string with a different text.
Remove unwanted text from cell with Text to Columns function Kutools for Excel: with more than handy Excel add-ins, free to try with no limitation in 60.
3 ways to remove spaces between words / numbers in Excel cells Excel has the Trim formula to use for deleting extra spaces from text. Feel free to use some tips from Enter the same formula into all selected cells at a time.