Importing data from Excel to MS Dynamics CRM

[TomasSK]

Hi,

pls can anybody help me with this. I am using ERP System. I access it over the terminal conection. There is the MS Office 2007 version installed on Remote Server. ERP supports exports to these formats Attached File: screenshot_0.
I did export customers data to excel file even try to text fila - ANSI. On my workstation I am using Office 2010. No matter what exported file I use, I always end up with this. In the excel cell this string is always added to every record: "´". Fro exampe: In excel cell I see:
Jano Klak, but when I go to excel editing line it is like this:´Jano Klak how do I remov this symbol"´". Pls see attached file screenshot_1.

Thanx for Help

Tomas

[martindwilson]

what does it affect? you can usually ignore it
a1='martin b1=martin a1=b1=true =MATCH(B1,A1:A2,0) =1
or put 1 in a spare cell copy , then select all data paste special- multiply. that will remove it