Question about character entities management in Excel files (SDL Trados)

Question

Hello, I am a Freelance translator and I am trying the SDL Studio Trados 2015 to see if it can help me with website translations. Usually, my clients send me Excel files with HTML code embedded. I learnt how to filter the embedded code, but I don't know how to manage the character entities (for example á for the character á or à forthe character à ). If I work with an HTML file, SDL Trados can support the conversion of entities (Latin 1 in our case). So if I write the character á , SDL Trados will actually write á in the HTML file (as any HTML editor). However, if I work with an Excel file, I'm only able to filter tags like

or others, but I cannot convert entities. Is there any solution to that? Any configuration I can do? Please let me know. Thank you in advance. Javier

Paul · Accepted Answer

Hi Javier, You won't be able to convert the entities but you can protect them as placeholder tags using the embedded content processor. Try this as a catchall... think it will get most: &\w+; 
 If you want to go the other way then this won't be possible at all... you'd have to write the entities themselves. I guess you could do that with quick inserts, or maybe using autocorrect perhaps? 
 Regards Paul

Trados Studio > 1. Trados Studio

Question about character entities management in Excel files (SDL Trados)