VBA copy/paste

p45cal · #1 05-13-2018, 05:16 AM

It may not need a macro; if you have a version of Excel which has the TextJoin worksheet function you could have in G2:
=TEXTJOIN(" ",TRUE,A2:E4)
or:

=TEXTJOIN(" ",FALSE,A2:E4)
depending upon how you want to treat empty cells.

Then if you want to lose the formula you can copy, paste-special, Values afterwards.

Urraco · #2 05-14-2018, 03:07 AM

Quote:

Originally Posted by p45cal

It may not need a macro; if you have a version of Excel which has the TextJoin worksheet function you could have in G2:
=TEXTJOIN(" ",TRUE,A2:E4)
or:
=TEXTJOIN(" ",FALSE,A2:E4)
depending upon how you want to treat empty cells.

Then if you want to lose the formula you can copy, paste-special, Values afterwards.

TextJoin is a good solution but my excel does not have this function.
Thanks for the reply.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When I copy&paste a second copy appears that can't be edited	makeo22	Word	3	04-26-2017 07:09 PM
Copy n Paste	seimeinokigen	Excel	2	04-16-2016 09:31 AM
Paste and Copy	Quadro	Excel	4	07-15-2014 05:59 AM
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM
Can't copy paste	irenasobolewska	Office	2	10-26-2012 05:09 PM