Home

Fixing accents errors in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-817048%22%20slang%3D%22en-US%22%3EFixing%20accents%20errors%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20to%20download%20some%20text%20data%20in%20Portuguese%20which%20comes%20with%20accents%20(e.g.%20%C3%A3%2C%20%C3%AD%2C%20%C3%A9%2C%20...).%20The%20website%20gives%20me%20the%20option%20to%20download%20the%20file%20either%20in%20excel%20or%20pdf.%20Although%20I%20want%20the%20data%20in%20excel%2C%20it%20reads%20the%20accents%20with%20error%20whereas%20pdf%20doesn't%20(the%20files%20are%20attached).%20Would%20anyone%20know%20how%20to%20fix%20such%20errors%20in%20excel%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EMany%20thanks%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EPaula%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-817048%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817092%22%20slang%3D%22en-US%22%3ERe%3A%20Fixing%20accents%20errors%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396715%22%20target%3D%22_blank%22%3E%40PaulaSpinola%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Paula%3C%2FP%3E%3COL%3E%3CLI%3EClick%20on%20the%20File%20Tab%20%26gt%3B%26gt%3B%20Click%20Options%20(or%20use%20the%20Shortcut%20ALT%20F%20T)%3C%2FLI%3E%3CLI%3EClick%20on%20Language%3C%2FLI%3E%3CLI%3EClick%20on%20the%20Drop%20list%20for%20selecting%20a%20language%3C%2FLI%3E%3CLI%3ESelect%20Portuguese%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20845px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128002iE3C820272728F31B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22language.png%22%20title%3D%22language.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-819675%22%20slang%3D%22en-US%22%3ERe%3A%20Fixing%20accents%20errors%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-819675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20However%2C%20I%20already%20have%20Portuguese%20as%20one%20of%20the%20languages.%20I%20think%20the%20problem%20was%20generated%20in%20the%20system%20where%20the%20file%20was%20generated.%20I%20guess%20this%20means%20there%20is%20no%20way%20to%20recover%20the%20original%20accents%20(or%20likewise%20recover%20the%20data%20without%20any%20accents%20or%20errors%20coming%20from%20them)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128161i5A8C4E09697CD578%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-819693%22%20slang%3D%22en-US%22%3ERe%3A%20Fixing%20accents%20errors%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-819693%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396715%22%20target%3D%22_blank%22%3E%40PaulaSpinola%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20Paula%2C%20that%20could%20be%20a%20possibility%20!!%3CBR%20%2F%3EI'm%20using%20multiple%20languages%20on%20my%20laptop%20and%20all%20what%20I%20do%20is%20to%20add%20the%20language%20as%20I%20sowed%20earlier%20and%20select%20the%20language%20from%20the%20Language%20settings%20in%20the%20Windows%20Settings%20(or%20from%20the%20right%20side%20of%20the%20Task%20Bar)%3CBR%20%2F%3EHope%20I%20could%20help%20more.%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
PaulaSpinola
Occasional Contributor

I need to download some text data in Portuguese which comes with accents (e.g. ã, í, é, ...). The website gives me the option to download the file either in excel or pdf. Although I want the data in excel, it reads the accents with error whereas pdf doesn't (the files are attached). Would anyone know how to fix such errors in excel?
Many thanks
Paula

3 Replies

@PaulaSpinola 

Hi Paula

  1. Click on the File Tab >> Click Options (or use the Shortcut ALT F T)
  2. Click on Language
  3. Click on the Drop list for selecting a language
  4. Select Portuguese

language.png

 

Hope that Helps

Nabil Mourad

@nabilmourad 

Thanks! However, I already have Portuguese as one of the languages. I think the problem was generated in the system where the file was generated. I guess this means there is no way to recover the original accents (or likewise recover the data without any accents or errors coming from them)?

 

clipboard_image_0.png

@PaulaSpinola 

Unfortunately Paula, that could be a possibility !!
I'm using multiple languages on my laptop and all what I do is to add the language as I sowed earlier and select the language from the Language settings in the Windows Settings (or from the right side of the Task Bar)
Hope I could help more.

Nabil Mourad

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies