Mobile menu

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: 00:47
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: 22:47
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

Translation news related to SDL Trados

Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »

All of
  • All of
  • Term search
  • Jobs