Copy , concatenate and finally paste

Closed
mishthi - Jan 31, 2017 at 02:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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