|
Thank you so much, Joe! With my limited knowledge of Excel, I feared I would have to enter "1" in manually a gazillion times in order to do this.
Could you possibly elaborate upon the "paste special" step, please? I have tried both options Excel seems to present and both times all the text has been pasted in the first column. Thanks!
Last edited by ChiefWahoo; 09-12-2017 at 10:20 PM.
|