தொழில்நுட்ப மன்றங்கள் » CafeTran support »
Merging cells in Excel projects
இழை இடுபவர்: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
Mar 4

Here I will describe how to merge cells in Excel projects.
 
Dan Lucas
Dan Lucas  Identity Verified
யுனைடட் கிங்டம்
Local time: 00:47
உறுப்பினர் (2014)
ஜேபனீஸ் - ஆங்கிலம்
Gently does it Mar 4

I'm cautious about merging cells even in Excel, let alone a CAT tool 😬

Dan

CafeTran Trainer
 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
You're right Mar 4

Dan Lucas wrote:

I'm cautious about merging cells even in Excel, let alone a CAT tool 😬

Dan


You are absolutely right, Dan. By the way, why do Japanese agencies use Excel for translation projects?
 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
Screenshot Mar 4

Here is a screenshot from the other thread. I'll provide more info ASAP.

Image-000463
 
Samuraidog
Samuraidog
யுனைடட் ஸ்டேத்ஸ்
Local time: 19:47
ஜேபனீஸ் - ஆங்கிலம்
Thank you! Mar 4

CafeTran Trainer wrote:

Here is a screenshot from the other thread. I'll provide more info ASAP.

Image-000463


Fantastic! Thank you for posting this.
 
Samuraidog
Samuraidog
யுனைடட் ஸ்டேத்ஸ்
Local time: 19:47
ஜேபனீஸ் - ஆங்கிலம்
It's the authors Mar 4

CafeTran Trainer wrote:

Dan Lucas wrote:

I'm cautious about merging cells even in Excel, let alone a CAT tool 😬

Dan


You are absolutely right, Dan. By the way, why do Japanese agencies use Excel for translation projects?


It's the authors of the original document that like to use Excel. Japanese can tend to be constructed in blocks, so Excel may seem appealing as it is also constructed in blocks.
Also, Excel can seem to be the perfect solution, as you can write text, insert text boxes, insert charts, insert formulas, control cell width, etc.
I agree that it makes it a pain to have to deal with for a translator.

[Edited at 2025-03-04 10:58 GMT]
 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
Interesting Mar 4

Samuraidog wrote:

Japanese can tend to be constructed in blocks, so Excel may seem appealing as it is also constructed in blocks.


Can you elaborate a little on that?
 
Samuraidog
Samuraidog
யுனைடட் ஸ்டேத்ஸ்
Local time: 19:47
ஜேபனீஸ் - ஆங்கிலம்
Here is a little context Mar 4

CafeTran Trainer wrote:

Samuraidog wrote:

Japanese can tend to be constructed in blocks, so Excel may seem appealing as it is also constructed in blocks.


Can you elaborate a little on that?


Maybe I'm making a generalization, as all languages are complex, and contain nuance. Others who know the language well may disagree with my viewpoint. However, Japanese usually contains kanji (Chinese characters) with words constructed of multiple kanji ideograms (that someone could construe as a block/square).

This article does a better job of explaining kanji than I could in a forum post.
https://www.japan-guide.com/e/e2046.html

And, perhaps this article will give you a good visual on how Japanese may read (or be learned) with kana text presented in the form of a table/matrix (that looks like Excel).
https://www.nihongoproject.com/the-kana-building-blocks-of-japanese/

https://en.wikipedia.org/wiki/Genkō_yōshi

I've seen Excel files where each cell contains one Japanese kanji, katakana, or hiragana letter. As a translator, it is maddening that someone would choose to write that way, and you are expected to make it make sense in English, but I've seen it multiple times in Excel!


[Edited at 2025-03-04 14:19 GMT]

[Edited at 2025-03-04 19:37 GMT]

CafeTran Trainer
 
CafeTran Trainer
CafeTran Trainer
நெதர்லாந்து
உறுப்பினர் (2006)
தலைப்பை ஆரம்பித்தல்
Virtual merging Mar 5

Dan Lucas wrote:

I'm cautious about merging cells even in Excel, let alone a CAT tool 😬

Dan


CafeTran Espresso only virtually merges cells in the translation project. It doesn't merge cells in the exported Excel file.

Dan Lucas
 


To report site rules violations or get help, contact a site moderator:

இந்த மன்றத்துக்கான மட்டுறுத்துனர்கள்
Natalie[Call to this topic]

You can also contact site staff by submitting a support request »

Merging cells in Excel projects






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

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