• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Spanish characters not displaying.

Hi Experts,

I have a CSV file that contains Spanish characters. Word and Access display them but Excel does not. My version of Office is 2002.
0
DColin
Asked:
DColin
  • 2
1 Solution
 
ShaileshShindeCommented:
Hi,

Can you please provide the sample file for this.

Thanks,
Shail
0
 
DColinAuthor Commented:
Sample file.
Brazil.csv
0
 
ShaileshShindeCommented:
Hi,

I have downloaded your .csv file and open it in Emeditor and it shows encoding as UTF-8 with Signature. I save as this file into encoding UTF-16LE without Signature and open it in Excel 2007 and found all Spanish characters were displayed correctly.

Attached Brazil2.csv for your reference.

Thanks,
Shail
Brazil2.csv
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now