Copy , concatenate and finally paste [Closed]

- - Latest reply: TrowaD
Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
- Feb 7, 2017 at 11:51 AM
Hello,

I have a problem that is:
Firstly i have to copy the same cell (value, anything or blank) from two different Excel and concatenate them all and finally paste in the another Excel of the same cell.



See more 

1 reply

Posts
2559
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2019
370
0
Thank you
Hi Mishthi,

Open both source files and your destination file. In your destination file use the formula CONCATENATE and select the cells from the source files as you would with a single file.

Best regards,
Trowa