Copy , concatenate and finally paste

Closed
mishthi - Jan 31, 2017 at 02:16 AM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
- 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.



1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Feb 7, 2017 at 11:51 AM
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
0