Translation - art & business » Translators Associations »
Merging Excel cells
Thread poster: Jean-Christophe Duc
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 17:44
English to French
+ ...
Oct 12, 2016

Is it possible to merge automatically two Excel sheets (say 1 and 2), so that the column A of sheet 2 becomes the column B of sheet 1?

[Edited at 2016-10-12 17:11 GMT]
 
Christian christian@nielsen-palacios.com
Christian [email protected]
United States
Local time: 11:44
English to Spanish
+ ...
Cut and paste? Oct 12, 2016

I am no expert, but cut and paste should work... COPY and paste, to be safe.

[Edited at 2016-10-12 15:43 GMT]
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 17:44
English to French
+ ...
TOPIC STARTER
It sure works... Oct 12, 2016

... but when sheets have up to 10 or 20 tabs, it quickly becomes boring.
Hence, an automatic or semi-automatic solution would help...
 
Platary (X)
Platary (X)
Local time: 17:44
German to French
+ ...
A macro Oct 12, 2016

does it very simple. Try something like the following :

Sub CopieAE()

Range("B1").Select
Sheets("Feuil2").Columns("A:C").Copy Sheets("Feuil1").Columns(2)

End Sub

Run this macro in the target sheet and adapt of course the sheet number (or name) to be copied and the range (from to columns).

Done!

Otherwhise you could also wrtite such a following formula (to be adapted of course) in B1 in the target... See more
does it very simple. Try something like the following :

Sub CopieAE()

Range("B1").Select
Sheets("Feuil2").Columns("A:C").Copy Sheets("Feuil1").Columns(2)

End Sub

Run this macro in the target sheet and adapt of course the sheet number (or name) to be copied and the range (from to columns).

Done!

Otherwhise you could also wrtite such a following formula (to be adapted of course) in B1 in the target sheet :

Feuil2!RC[-5]:R[1]C[-5]

which could also be inserted in another macro :

Sub sheetinsheet()

ActiveCell.FormulaR1C1 = "=Feuil2!RC[-5]:R[1]C[-5]"
Range("I1").Select
Selection.AutoFill Destination:=Range("I1:I25"), Type:=xlFillDefault

End Sub

Hope this helps, other possibilities may exist, but i know these are working.

Good luck! ▲ Collapse
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 17:44
English to French
+ ...
TOPIC STARTER
Thanks Oct 12, 2016

I'll look into it.
Is there a way to iterate it for n number of tabs?
 
Alison High
Alison High  Identity Verified
Switzerland
Local time: 17:44
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 you need to add a space between ... See more
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.


=CONCATENER(A1;" ";B1)
 ▲ Collapse
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 17:44
English to French
+ ...
TOPIC STARTER
Thanks, but... Oct 14, 2016

... I need to merge two different sheets, not cells.
 


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

Moderator(s) of this forum
Jorge Rodrigues[Call to this topic]
Nawal Kramer[Call to this topic]

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

Merging Excel cells







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 »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »