Search and replace in Excel
Thread poster: Edward Potter

Edward Potter  Identity Verified
Spain
Local time: 10:23
Member (2003)
Spanish to English
+ ...
Sep 4, 2006

I am having a problem using WordFast. Can anyone help? I am using Word Professional Edition 2003 on an XP platform.

When translating an Excel file all of the carriage returns were converted into a double male/mars symbol ( ).

I have attempted to search and replace but when I key in the ascii code (ALT-11) and attempt a search, Excel does not recognize this character and finds nothing.

Please tell me how I can replace these symbols with a carriage return.

Thank you.

Edward Potter


Direct link Reply with quote
 
Charlie Bavington  Identity Verified
Local time: 09:23
French to English
possibility Sep 4, 2006

does Excel find the symbol if you copy and paste it into the search box from Word (for instance)?
I sometimes use this approach to get Excel to find accented characters...


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 »

Search and replace in Excel

Advanced search


Translation news related to Wordfast





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



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