How to insert line break in Excel cells?
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Finland
Local time: 13:59
Member (2003)
Finnish to German
+ ...
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  Identity Verified
Ukraine
Local time: 13:59
Member (2008)
English to Russian
+ ...
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  Identity Verified
Netherlands
Local time: 12:59
Member (2006)
English to Afrikaans
+ ...
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  Identity Verified
Finland
Local time: 13:59
Member (2003)
Finnish to German
+ ...
TOPIC STARTER
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
France
Local time: 12:59
Member
French to English
+ ...
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  Identity Verified
Czech Republic
Local time: 12:59
English to Czech
+ ...
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
- voilaicon_smile.gif

I am not sure if it is possible to do it in all versions, but in 2007 it works


 

István Hirsch  Identity Verified
Local time: 12:59
English to Hungarian
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  Identity Verified
France
Local time: 12:59
French to English
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 there – just blank)
4) Now you have your text back in Excel, with line breaks as they should be!


 


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


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

How to insert line break in Excel cells?

Advanced search






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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