I have a big list of numbers that I'm trying to import into a CRM. The problem is this CRM will only import records with numbers only. Some of this data has letters and other weird characters mixed-in with the numbers. Is there a function or formula that will look at a column of numbers and only take the numeric characters and leave everything else out and then paste it into a new column. I've attached an example of what I want to happen.
Column A is what the data looks like now. Column B is what I want it to look like after the formula.
Bookmarks