News for hackers. Stuff that matters.
Re:Excel: Getting rid of everything except numbers by countmora on Sunday July 17, 2022 @08:32PM (#32133122)
So a lot of comments here suggest copying it to another application and process it there.

Two points from my side why I would not do that:

First, you can do this directly in Excel either with a regex expression in a macro [0] or PowerQuery [1].

Secondly, I don’t know about the authors example but generally if you have to do something like this the column is likely to be one out of many, i.e., part of a table. I can’t point my finger to it but I imagine there might be a lot of steps in that process that could go wrong (formatting issues, altering table scheme, etc.)

[0] https://software-solutions-online.com/vba-regex-guide/

[1] https://www.myonlinetraininghub.com/extract-letters-numbers-...

There are no comments on this comment yet.