VBA copy/paste

Urraco · #3 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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