Copy , concatenate and finally paste [Closed]

Report
-
Posts
2720
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 19, 2021
-
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

Posts
2720
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 19, 2021
459
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!