Daniel:

You are the man. Thank you very much.

Sleepindogg

"Daniel CHEN" wrote:

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

"sleepindogg" wrote in message
...
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?