|
|
#1
04-26-2017, 06:31 AM
|
|||
|
|||
Copying data in a column to another column
Hello!
I have combined the data from five columns into one column using: =CONCATENATE(H2,I2,J2,K2,L2) Now I want to copy the resulting data into a new column. After it is copied into the new column, I want to delete the five columns and the concatenate column, so I'm just left with the results. Could someone explain how to go about doing this? Thank you! 
|
|
#2
04-26-2017, 08:30 AM
|
||||
|
||||
|
Perhaps Copy - Paste special - Values
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
04-28-2017, 12:31 AM
|
|||
|
|||
|
Thank you very much! That was easy and did the trick. (I'm still new to Excel!)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copying DNA from web and need to convert column date to ex: 11-15
|
JacMUr2 | Excel | 2 | 01-22-2016 03:36 AM |
| Help with Macro - copying formula to last line of data based on another column | kidwispa | Excel Programming | 1 | 07-12-2015 05:01 PM |
| Copy column 1 data into Column 3 | ShailShin | Word VBA | 1 | 06-18-2015 10:49 AM |
| How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |
| Copying column to column automatically? | Cemetery | Excel | 2 | 08-10-2013 05:20 PM |
Mac OS X 
Office for Mac 2011
Linear Mode
