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 t

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/ https://software-solutions-online.com/vba-regex-guide/ [1] https://www.myonlinetraininghub.com/extract-letters-numbers-symbols-from-strings-in-power-query-with-text-select-and-text-remove https://www.myonlinetraininghub.com/extract-letters-numbers-...