Any settings for colored bilingual excel files?
Thread poster: Ali Bayraktar
Ali Bayraktar  Identity Verified
Turkey
Member (2007)
English to Turkish
+ ...
Dec 15, 2016

I have an excel file to translate.
Text to be translated located in the column A.
But in column A I dont need to translate all rows.
Among 5000 rows I need to translate only the rows colored in YELLOW.
Is there any quick settings for this purpose?

Thanks in advance

Best,

M. Ali


Direct link Reply with quote
 

Kirsten Bodart  Identity Verified
United Kingdom
Local time: 01:30
Dutch to English
+ ...
I don't think so Dec 15, 2016

but as a work-around I think the best way to go is:

1. Copy-paste all of column A into column B.
2. Hit ctrl + f (find/replace) and find all things with a white background (or no background colour, see the format section if you go to the advanced options in find/replace I think) and replace those with no text (so delete all text, automatically).
3. Check quickly if the only text left in column B is the cells in yellow.
4. Import with options in MemoQ, selecting the 'only import these ranges' and select in file option which opens the file in Excel.
5. Select all of column B as a range, add to range and then finish.

Then you should have only the yellow cells.

Alternatively, if the cells are not too numerous or not too few and far between, you can just copy them manually and start at 4.


Direct link Reply with quote
 

Annamaria Amik  Identity Verified
Local time: 02:30
Romanian to English
+ ...
Another improvized option - Sort by color in Excel Dec 15, 2016

I have only checked this on a few cells, but you could try this, working with a copy of your original, of course.
1) Copy your source column to the colum in which you need to write the translation. Or just select the source column, if that's where you have to write it.
2) Go to Filter (Home tab in Excel 2010). This will create a drop-down list sort of thingy, with an arrow in the top row. Pressing that, you can Sort by color. You should be able to sort by yellow. This will arrange the rows by color.
(You can also Filter by color. This will hide all but the yellow rows. Not sure if MemoQ will only import these visible rows. It should, but you need to check first.)

Then proceed as Kirsten said, Import with options in MemoQ and select that range. Now that they are arranged by color, it should take a click or two to select all the yellow ones, you don't have to select hundreds of scattered rows.

[Edited at 2016-12-15 13:14 GMT]


Direct link Reply with quote
 
Ali Bayraktar  Identity Verified
Turkey
Member (2007)
English to Turkish
+ ...


Posted via
ProZ.com Mobile


TOPIC STARTER
Thanks Dec 16, 2016

Sorry for my late post
I was busy but I read your suggestions
Thanks Kirsten and Annamaria for your time and efforts
Wish all happy new year in advance

Best,

M. Ali


Direct link Reply with quote
 

Kirsten Bodart  Identity Verified
United Kingdom
Local time: 01:30
Dutch to English
+ ...
The sort option Dec 16, 2016

is not a bad one either. I'll think about that one too!

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 »

Any settings for colored bilingual excel files?

Advanced search






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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