I am pasting into column A row 1 and need a macro I can apply to a button that takes out all text from what has been pasted and leaves every row with the same digits just without text.
Often times there will be up to 75 rows pasted in column A.
I need a macro that I can apply to a button to...