|
|
#2
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2010 32bit
Threaded Mode