Hello,
Is there any way to either extract or isolate for translation only the text in bold in an Excel file with many tabs (every worksheet consists of a significant number of columns and/or rows)?
Any advice and/or guidance on how to proceed would be most welcomed.
Thank you in advance for your help.
Not within Studio. You could try to color all cells, then use Excel's find function to find all bold cells and apply "no fill color" to them. Then tell Studio to exclude cells with the color you used for all other cells.
Daniel
As Daniel Hug mentioned the best approach is probably to use colours in Excel. But if the bold text is within a cell and not the entire cell then it would be possible to use the Advanced Display Filter in Studio. For example if you have this:
You could do this:
And now you see this:
So a bit limited as you are probably talking about the entire cells being bold.
Paul Filkin | RWS
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Thank you so much, Daniel!
Indeed, this method worked just fine —I just applied a macro for coloring across the tabs.
I really appreciate your help.
Best regards,
Gilberto
Thank you, Paul —as always!
Yes, except for a very exceptions, my entire cells are bold —nonetheless, this method is an extra little resource to keep in my toolbox.
Best regards,
Gilberto
Translate
