This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
How to search and replace for manual line break in Excel?
Thread poster: Jerzy Czopik
Jerzy Czopik Germany Local time: 07:30 Member (2003) Polish to German + ...
Dec 9, 2008
My Excel file contains cells with manual line breaks ("alt + enter"). Before I translate the text I would like to remove them, replacing by a code (for example <br>) and then after the translation replace it back again. Excel seems not to support this, so I have to find our which code I should use for that. I think haveing read something similar on ProZ some time ago, but fail to find the corresponding topic.
Thanks a bunch Best regards Jerzy
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Selcuk Akyuz Türkiye Local time: 09:30 English to Turkish + ...
The answer is to remember that you can enter any ASCII code into the "Find What" box by holding down the Alt key and using the numeric keypad. Since the ASCII code for the line break is 10, you can follow these steps:
1. Press Ctrl+F to display the Find tab of the Find and Rep... See more
The answer is to remember that you can enter any ASCII code into the "Find What" box by holding down the Alt key and using the numeric keypad. Since the ASCII code for the line break is 10, you can follow these steps:
1. Press Ctrl+F to display the Find tab of the Find and Replace dialog box. (Click here to see a related figure.) 2. In the Find What box, hold down the Alt key as you type 0010 on the numeric keypad. It may not look like anything is in the Find What box, but the character is there. 3. Click Find Next.
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.