Substitutions in Excel
Thread poster: Rufino Pérez De La Sierra
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
| 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.
| 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.
| 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.
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.
| Try this - It will work! || Jul 1, 2008 |
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!
| I'm saving this info ... || Jul 1, 2008 |
Carlos Montilla wrote:
The system worked for me!
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 ...
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
|Translation Memory Software for Any Platform|
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
More info »
|SDL Trados Studio 2017 Freelance|
|The leading translation software used by over 250,000 translators.|
SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.
More info »