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

Elena Ghetti  Identity Verified
Italy
Local time: 00:16
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)


Direct link Reply with quote
 

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]


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 »

need to add text cells in Access/Excel

Advanced search






LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

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



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