Ask a question
A few words of thanks would be greatly appreciated.
The problem is that the presence of the apostrophe simply means that the content of your cells is Text.
So, you can use text to column option located under the "DATA" menu.
Copy Data to Another Workbook in Excel
Excel - Copy row and insert n times