Hard return in Excel with SDLX
Thread poster: Jean-S�bastien FEREY

Jean-S�bastien FEREY
English to French
Jan 8, 2007

Hi all,

This is my first post on proz.

I currently have a project for a client (Excel) that is quite big in term of volume and I would like to use SDLX to transalte the Excel files.

My main concern is some cells have their text divided in several lines, each of them separated by a hard return carriage (Alt+Enter).

I tried to import the files with my SDLX segmentation rule set to paragraph, but it imports them lines by lines. Let's say a cell in the Excel files has 6 lines, all separated by a hard return carriage; the result I have with SDLX is 6 separated lines instead of a paragraph.

Does anybody know how I could create a segmentation rule that would alllow me to import each cell as a separated paragraph of text?

Thanks in advance for your help.


Direct link Reply with quote

Heinrich Pesch  Identity Verified
Local time: 08:54
Member (2003)
Finnish to German
+ ...
Did you try to export the cells to Word first? Jan 8, 2007

I never try to translate straight from Excel, instead I copy the cells to Word. When copying the translation bach into Excel I found it useful to use Open Office instead of excel, because it is more compatible with Word-files and you won't get any additional cells where there are linebreaks in the text.

Direct link Reply with quote

Marta Fernandez-Suarez  Identity Verified
United Kingdom
Local time: 06:54
English to Spanish
I think there is no problem Jan 9, 2007

Hello Jéan

I've just done a test with a mini-Excell file in which I inserted two lines in one cell (by doing Alt Enter) and there is no problem. You do see two separate lines in the bilingual itd, but when you do a preview of the translated text, you'll see that the format is the same: two lines in one cell.

Please, write to me directly if you want to ask me my settings.

Kind regards,


Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Hard return in Excel with SDLX

Advanced search

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »

  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search