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
The Best of CCM in Your Inbox
The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy .
DON'T MISS