Technical forums » Office applications »
How to search and replace for manual line break in Excel?
Thread poster: Jerzy Czopik
Jerzy Czopik
Jerzy Czopik  Identity Verified
Germany
Local time: 06:04
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
 
Selcuk Akyuz
Selcuk Akyuz  Identity Verified
Türkiye
Local time: 07:04
English to Turkish
+ ...
0010 Dec 9, 2008

http://excel.tips.net/Pages/T003220_Searching_for_Line_Breaks.html

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
http://excel.tips.net/Pages/T003220_Searching_for_Line_Breaks.html

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.



HTH

Selcuk ▲ Collapse
 
Jerzy Czopik
Jerzy Czopik  Identity Verified
Germany
Local time: 06:04
Member (2003)
Polish to German
+ ...
TOPIC STARTER
Thanks - exactly that was it Dec 9, 2008

and it worked.

Thanks again and best regards
Jerzy
 
Spiros Doikas
Spiros Doikas  Identity Verified
Local time: 07:04
Member (2002)
English to Greek
+ ...
Asap-utilities Dec 9, 2008

A brilliant, free, excel add-on.
http://www.asap-utilities.com/
 
Lori Cirefice
Lori Cirefice  Identity Verified
France
Local time: 06:04
French to English
Line breaks in excel Dec 9, 2008

http://www.proz.com/prozwiki/en:Wordfast_how_to

in case anyone searches for this in the future, it's explained at the very bottom of this article
 
Gerard de Noord
Gerard de Noord  Identity Verified
France
Local time: 06:04
Member (2003)
English to Dutch
+ ...
I think there are several line breaks to be considered Dec 9, 2008

Hi Jerzy,

My own Excel macros look for Chr(9), Chr(10) and Chr(13).

Just for future reference,
Gerard
 


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

Moderator(s) of this forum
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 search and replace for manual line break in Excel?






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 »
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 »