A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2006, 04:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Combining Text from 2 Columns into 1 then Deleting the 2 Columns

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?


  #2  
Old March 30th, 2006, 05:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Combining Text from 2 Columns into 1 then Deleting the 2 Columns

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?




  #3  
Old March 30th, 2006, 05:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Combining Text from 2 Columns into 1 then Deleting the 2 Columns

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 EditPaste SpecialValues.

Now you can delete the original columns C & D
"sleepindogg" wrote:

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?


  #4  
Old March 30th, 2006, 07:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Combining Text from 2 Columns into 1 then Deleting the 2 Colum

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?





  #5  
Old March 30th, 2006, 07:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Combining Text from 2 Columns into 1 then Deleting the 2 Colum

Duke:

You got the right name. Thanks for the help.

Sleepindogg

"Duke Carey" wrote:

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 EditPaste SpecialValues.

Now you can delete the original columns C & D
"sleepindogg" wrote:

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?


  #6  
Old September 19th, 2008, 12:36 AM posted to microsoft.public.excel.worksheet.functions
wtdrm
external usenet poster
 
Posts: 6
Default Combining Text from 2 Columns into 1 then Deleting the 2 Colum

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

--
wtdrm


"sleepindogg" wrote:

Duke:

You got the right name. Thanks for the help.

Sleepindogg

"Duke Carey" wrote:

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 EditPaste SpecialValues.

Now you can delete the original columns C & D
"sleepindogg" wrote:

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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking text boxes Volunteer Mom Publisher 7 November 12th, 2008 02:29 AM
Is Access even the right idea? BMB New Users 19 November 21st, 2005 09:01 PM
Ideas On Producing Envelopes & Labels For Data RNUSZ@OKDPS Setting Up & Running Reports 0 April 28th, 2005 03:22 PM
Help with design Ronnie Database Design 6 March 12th, 2005 03:53 PM
Outline Renee Hendershott Page Layout 2 December 25th, 2004 03:49 PM


All times are GMT +1. The time now is 02:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.