I have read some topics explaining how to do this, which would be incredibly slow. The explanation is here: https://www.extendoffice.com/documents/excel/651-excel-remove-non-numeric-characters.html
It involves iterating through each cell in a range and then iterating through the characters in the field and removing them if they do not match [0-9]
.
Any suggestions to do this more efficiently?
One that comes to mind is loading the cell contents into an array, iterating through it, and splitting each entry into its own array to iterate through.
See Question&Answers more detail:os