منتديات تقنية » Office applications »
How to insert line break in Excel cells?
ناشر الموضوع: Heinrich Pesch
Heinrich Pesch
Heinrich Pesch  Identity Verified
فنلندا
Local time: 23:04
عضو (2003)
فنلندي إلى ألماني
+ ...
May 29, 2013

I was translating software strings in Trados 2007 TE. I had copied the columns into Word doc and translated in TE.
The customer needs some cells to be formatted exactly like the source: two short lines with a line break:

String1
String2

But though in TagEditor there were br-tags in place, which I kept, after copying to Excel I get:

String1 String2

What can I do to make it right?
In Word the cells look still ok.
 
Andriy Yasharov
Andriy Yasharov  Identity Verified
أوكرانيا
Local time: 23:04
عضو (2008)
أنجليزي إلى روسي
+ ...
Alt-Enter May 29, 2013

Place your cursor after the required word in an Excel cell and press Alt+Enter. That should work.
 
Samuel Murray
Samuel Murray  Identity Verified
هولندا
Local time: 22:04
عضو (2006)
أنجليزي إلى أفيقاني
+ ...
There is no way... May 29, 2013

Heinrich Pesch wrote:
What can I do to make it right?
In Word the cells look still ok.


There is no way to copy text from MS Word into MS Excel with line breaks intact, even if you use soft line breaks in MS Word. You must perform the line breaks in Excel. This means that in MS Word you must replace the line breaks with e.g. "###" and then you must search for them in Excel and use Alt+Enter to insert the line break at that point.

You can perform a find/replace in Excel, with line breaks, but it is a little tricky, because the "replace" box will appear to be empty even though it isn't, if you do it right. I can't remember how to type that line break in the replace box, though -- I always just google for it whenever I want to do it.
 
Heinrich Pesch
Heinrich Pesch  Identity Verified
فنلندا
Local time: 23:04
عضو (2003)
فنلندي إلى ألماني
+ ...
بادئ الموضوع
That worked, thanks! May 29, 2013

Andrey Yasharov wrote:

Place your cursor after the required word in an Excel cell and press Alt+Enter. That should work.


Fortunately there were only I few cell to be treated.
 
Tony M
Tony M
فرنسا
Local time: 22:04
عضو
فرنسي إلى أنجليزي
+ ...
مترجم الموقع
Alt + Num May 29, 2013

Samuel Murray wrote:

I can't remember how to type that line break in the replace box, though


If my memory serves me correctly, it is Alt + 010 — but like S.M. says, easiest to just Google it; and this topic has been discussed before in the ProZ.com forums too.
 
Pavel Mondschein
Pavel Mondschein  Identity Verified
جمهورية التشيك
Local time: 22:04
أنجليزي إلى تشيكي
+ ...
Actually there is a way :) May 29, 2013

Samuel Murray wrote:

There is no way to copy text from MS Word into MS Excel with line breaks intact, even if you use soft line breaks in MS Word.


Actually there is a way:
- copy the text from Word
- doubleclick on the cell in Excel to enter edit mode
- press Enter
- voila

I am not sure if it is possible to do it in all versions, but in 2007 it works
 
István Hirsch
István Hirsch  Identity Verified
Local time: 22:04
أنجليزي إلى مجري
If there are too many line breaks to insert manually in Excel May 29, 2013

This macro can insert/remove line breaks in a whole range of cells in a single step (free beta download):
http://www.excelfindandformatmacro.webs.com
 
Lori Cirefice
Lori Cirefice  Identity Verified
فرنسا
Local time: 22:04
فرنسي إلى أنجليزي
For future reference... May 29, 2013

1) On your clean Word file, Find and Replace ^l with XCXCXC (or any other strange string of letters).
2) Now copy the text from Word and paste in Excel. Make sure you still have the same amount of columns and lines as the original text.
3) Using the Excel Find and Replace, replace XCXCXC with Alt+010 (with the cursor in the "replace" field, hold down the 'Alt' button and type the numbers '010'. The field will remain blank, it looks like nothing happened, but in fact, it's th... See more
1) On your clean Word file, Find and Replace ^l with XCXCXC (or any other strange string of letters).
2) Now copy the text from Word and paste in Excel. Make sure you still have the same amount of columns and lines as the original text.
3) Using the Excel Find and Replace, replace XCXCXC with Alt+010 (with the cursor in the "replace" field, hold down the 'Alt' button and type the numbers '010'. The field will remain blank, it looks like nothing happened, but in fact, it's there – just blank)
4) Now you have your text back in Excel, with line breaks as they should be! ▲ Collapse
 


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

مشرفو هذا المنتدى
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

How to insert line break in Excel cells?






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 »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »