Combining Text from 2 Columns into 1 then Deleting the 2 Columns

G

Guest

I am attempting to merge text from two different columns ie. C2 and D2 into
one column. Once I have the data from the two columns in my new column, I
would like to delete the old columns and only use the new column with the
combined data.

Can anyone help?
 
D

Daniel CHEN

If you want to delete the original 2 columns, then you must do it manully or
use macro/vba code to achieve it. No exisiting excel function/formula can do
it.

BTW, you need to make the destination cells (new combined data) as values
not formulas before you delete the original two columns, o/w the values in
the destination cell will be changed.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
 
G

Guest

Insert an empty column adjacent to either C or D

In the new column use the formula

=C2 & D2
or, to put a space between them
=C2&" "&D2

Copy the formula down for all the rows, then copy all the cells with the
formula and, without changing the selection, use Edit>Paste Special>Values.

Now you can delete the original columns C & D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top