Mobile menu

Substitutions in Excel
Thread poster: Rufino Pérez De La Sierra

Rufino Pérez De La Sierra  Identity Verified
Canada
Local time: 11:38
English to Spanish
+ ...
Jun 30, 2008

Thanks in advance for your help.

I have just translated an Excel file, no problems. Problem is that all line brakes within cells (many of them, in every cell) were changed for a little square in the text...

I know I can manually select and replace the squares for a line break (Alt+enter), but there are more than a thousands squares...

Does anybody knows how to replace all of these automatically? When I try to copy and paste the squares nothing happens, and in the rReplace with field I cannot do the Alt+Enter.

Thanks in advance

Rufino


Direct link Reply with quote
 

Antoní­n Otáhal
Local time: 16:38
Member (2005)
English to Czech
+ ...
Export and S&R Jun 30, 2008

If there is no formatting, save as "tab delimited"
If formatting is an issue, save as "XML spreadsheet".

Now open in a good plain-text editor (such as UltraEdit) and search and replace. Standard Notepad might be able to cope with it, hard to say.

Import the resulting file back to Excel.

HTH

Antonin


Direct link Reply with quote
 

Lori Cirefice  Identity Verified
France
Local time: 16:38
French to English
Try this... Jun 30, 2008

http://www.proz.com/forum/office_applications/58886-replacements_in_excel.html#448138

One of these might work ... I'm sure I've read something somewhere on the ProZ forums more recently on this very problem, but I can't find it now (maybe it was a post by Heinrich Pesch?)


Direct link Reply with quote
 

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Thailand
Local time: 21:38
Partial member (2004)
English to Thai
+ ...
Find/Replace special characters in Excel Jul 1, 2008

Use Find/Replace special characters in Excel to "Replace all" in the worksheet or the entire file.
You can see line break marks and replace it with space etc.
If you can save as tab delimited file, open with MS Word. On Edit menu, go to Find> [check 'Highlight all'], select line break character from the special character tab, and press the Delete button to get rid of all line breaks at once. Import back to Excel.

Cheers,
Soonthon L.


Direct link Reply with quote
 

tectranslate ITS GmbH
Local time: 16:38
German
+ ...
Have you guys even tried what you're suggesting? Jul 1, 2008

Excuse me, but putting line breaks in tab delimited files will make it impossible to import those files in their original structure. Excel can export those, but not import them, same with Access.

And just replacing the breaks with nothing will give you textthat isglued togetherand looks reallyinteresting.

You may want to read up on a similar topic discussed in this thread.

HTH,
Benjamin

P.S.: We still don't know what you did exactly, Rufino, because you didn't mention what software you were using for the translation and what the steps involved were.


Direct link Reply with quote
 

Carlos Montilla
Local time: 16:38
English to Spanish
+ ...
Try this - It will work! Jul 1, 2008

Hi Rufino,

If you still haven't solved your problem, try this:

1) Select the text and copy it in word. The little squares will turn into line breaks.

2) Replace ^l for XCXCXC (every other strange combination will do). Also, replace ^p for XCXCXC, just in case.

3) Now copy the text in word and paste in excel. Make sure you still have the same amount of columns and lines as the original text.

4) Now replace XCXCXC for Alt+010 (this is the line break in excel, that's why you cannot enter alt+enter).

Ready! Your little squares are now line breaks!

Good luck!

Carlos


Direct link Reply with quote
 

Carlos Montilla
Local time: 16:38
English to Spanish
+ ...
That's it! Jul 1, 2008



Hi Lori,

I asked the question in that post. The system worked for me!

Regards,
Carlos


Direct link Reply with quote
 

Lori Cirefice  Identity Verified
France
Local time: 16:38
French to English
I'm saving this info ... Jul 1, 2008

Carlos Montilla wrote:

The system worked for me!

Regards,
Carlos


Good to know, I'm saving this info for future use, as I have come across this problem before, and dealt with it manually. I will probably have this problem again someday and won't remember what the solution is ...


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 »

Substitutions in Excel

Advanced search






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 »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



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