Forum Discussion

gtamir's avatar
gtamir
Icon for Post Patron rankPost Patron
8 years ago

#NAME?

Hi, After I loaded Sales table I got lot of errors in column "ProductName". The column in type TEXT. I went bake to the original excel file and found that there is a special character like +.  I lo...
Need Help
gtamir's avatar
gtamir
Icon for Post Patron rankPost Patron
8 years ago

I found the problem. I opened csv file in excel. then saved it as xlsx. So far so good.

After that I did something that I still have to investigate that when I saved it in another name it coused the error.

 

49906#NAME?
  
49906+ח.פBאקוסאפ ויט.מתיל12 

 

The second one is the original and the first is the result.

It is not the scop of the forum, but if you know what happend I'll be glad.

 

Giora

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi gtamir,

 

I think it may related to encode, maybe you can try to save your file as xlsx with unicode encode.


Regards,

Xiaoxin Sheng