This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
I'll look into it. Is there a way to iterate it for n number of tabs?
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Alison High Switzerland Local time: 18:06 French to English + ...
use concatenate formula
Oct 13, 2016
If the cells you want to merge are A1 and B1 and you want the merged result of A1 and B1 in C1 enter this formula in C1
=CONCATENATE(A1,B1)
To make it work for multiple rows just drag the bottom right corner of C1 (+ shaped cursor) down for as many rows as you want.... this automatically deploys the formula i.e. row 16 is now =CONCATENATE(A16,B16), which is the result of A16 merged with B16.
If the cells you want to merge are A1 and B1 and you want the merged result of A1 and B1 in C1 enter this formula in C1
=CONCATENATE(A1,B1)
To make it work for multiple rows just drag the bottom right corner of C1 (+ shaped cursor) down for as many rows as you want.... this automatically deploys the formula i.e. row 16 is now =CONCATENATE(A16,B16), which is the result of A16 merged with B16.
If you need to add a space between the content of the merged cells
=CONCATENATE(A1," ",B1)
For those using the French-Language version of excel you need the french formula word and semicolons, not commas.
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.
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.