need to add text cells in Access/Excel
Thread poster: Elena Ghetti

Elena Ghetti  Identity Verified
Italy
Local time: 22:12
Member (2003)
English to Italian
+ ...
May 19, 2004

I have a large personal glossary in Access and I need to add the contents of two or more cells into a new one that includes both texts i.e.

this is what I have now
column a/column b/column c
door/sportello/source A
door/porta/source A
door/sportello/source B

this is what I want to have:
column a/column b/column c
door/sportello/source A + source B
door/porta/source A

cannot do it manually as it is 100.000 plus lines to go through

thanks for any idea
PS (I have Office 2000 + XP)


 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
TShrink May 20, 2004

TShrink does exactly what you described.

It takes a tab-separated table and adds the contents of the respective fields, and it even uses the + symbol for concatenation.

Then it writes the resulting table into a tab-separated text file, a Trados TM import file and a MultiTerm import file.

It processes 100000 lines in 10 seconds.

If you contact me via my profile I can send you a free trial version.

Harry

Elena Ghetti wrote:

I have a large personal glossary in Access and I need to add the contents of two or more cells into a new one that includes both texts i.e.

this is what I have now
column a/column b/column c
door/sportello/source A
door/porta/source A
door/sportello/source B

this is what I want to have:
column a/column b/column c
door/sportello/source A + source B
door/porta/source A
...


[Edited at 2004-05-20 19:35]


 


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


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

need to add text cells in Access/Excel

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

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.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



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