software

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?
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
=================================

quot;sleepindoggquot; gt; wrote in message
...
gt;I am attempting to merge text from two different columns ie. C2 and D2 into
gt; one column. Once I have the data from the two columns in my new column, I
gt; would like to delete the old columns and only use the new column with the
gt; combined data.
gt;
gt; Can anyone help?
gt;
gt;
Insert an empty column adjacent to either C or D

In the new column use the formula

=C2 amp; D2
or, to put a space between them
=C2amp;quot; quot;amp;D2

Copy the formula down for all the rows, then copy all the cells with the
formula and, without changing the selection, use Editgt;Paste Specialgt;Values.

Now you can delete the original columns C amp; D
quot;sleepindoggquot; wrote:

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

Daniel:

You are the man. Thank you very much.

Sleepindogg

quot;Daniel CHENquot; wrote:

gt; If you want to delete the original 2 columns, then you must do it manully or
gt; use macro/vba code to achieve it. No exisiting excel function/formula can do
gt; it.
gt;
gt; BTW, you need to make the destination cells (new combined data) as values
gt; not formulas before you delete the original two columns, o/w the values in
gt; the destination cell will be changed.
gt;
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt; =================================
gt;
gt; quot;sleepindoggquot; gt; wrote in message
gt; ...
gt; gt;I am attempting to merge text from two different columns ie. C2 and D2 into
gt; gt; one column. Once I have the data from the two columns in my new column, I
gt; gt; would like to delete the old columns and only use the new column with the
gt; gt; combined data.
gt; gt;
gt; gt; Can anyone help?
gt; gt;
gt; gt;
gt;
gt;
gt;

Duke:

You got the right name. Thanks for the help.

Sleepindogg

quot;Duke Careyquot; wrote:

gt; Insert an empty column adjacent to either C or D
gt;
gt; In the new column use the formula
gt;
gt; =C2 amp; D2
gt; or, to put a space between them
gt; =C2amp;quot; quot;amp;D2
gt;
gt; Copy the formula down for all the rows, then copy all the cells with the
gt; formula and, without changing the selection, use Editgt;Paste Specialgt;Values.
gt;
gt; Now you can delete the original columns C amp; D
gt; quot;sleepindoggquot; wrote:
gt;
gt; gt; I am attempting to merge text from two different columns ie. C2 and D2 into
gt; gt; one column. Once I have the data from the two columns in my new column, I
gt; gt; would like to delete the old columns and only use the new column with the
gt; gt; combined data.
gt; gt;
gt; gt; Can anyone help?
gt; gt;
gt; gt;

Duke, you are an angel. You have saved me hours of time. Thanks for your post.

--
wtdrmquot;sleepindoggquot; wrote:

gt; Duke:
gt;
gt; You got the right name. Thanks for the help.
gt;
gt; Sleepindogg
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; Insert an empty column adjacent to either C or D
gt; gt;
gt; gt; In the new column use the formula
gt; gt;
gt; gt; =C2 amp; D2
gt; gt; or, to put a space between them
gt; gt; =C2amp;quot; quot;amp;D2
gt; gt;
gt; gt; Copy the formula down for all the rows, then copy all the cells with the
gt; gt; formula and, without changing the selection, use Editgt;Paste Specialgt;Values.
gt; gt;
gt; gt; Now you can delete the original columns C amp; D
gt; gt; quot;sleepindoggquot; wrote:
gt; gt;
gt; gt; gt; I am attempting to merge text from two different columns ie. C2 and D2 into
gt; gt; gt; one column. Once I have the data from the two columns in my new column, I
gt; gt; gt; would like to delete the old columns and only use the new column with the
gt; gt; gt; combined data.
gt; gt; gt;
gt; gt; gt; Can anyone help?
gt; gt; gt;
gt; gt; gt;