software

I am attempting to combine data from two different columns into one column.
Then I want to delete the two columns that I took the data from leaving only
the combined column data. Can anyone help?

Hi

Use the formula:
=A2amp;B2
If you want a space in between use:
=A2amp;quot; quot;amp;B2
You can then fill this down the column as far as needed. Select the column,
Ctrl C tocopy, then Edit/Paste Special/Values to paste the values in. Then
delete your other two columns.

Take a backup before you start!

Andy.

quot;sleepindoggquot; gt; wrote in message
...
gt;I am attempting to combine data from two different columns into one column.
gt; Then I want to delete the two columns that I took the data from leaving
gt; only
gt; the combined column data. Can anyone help?

Colum 1 Colum 2 = Colum 3

Colum 3 = Concatenate Cell (Colum 2) Cell (Colum2) Copy , then
Paste Value

If you want a space between data in C1 and C2

=Concatenate C1 (space) C2cheers--
Thiem
------------------------------------------------------------------------
Thiem's Profile: www.excelforum.com/member.php...oamp;userid=27474
View this thread: www.excelforum.com/showthread...hreadid=528148Andy:

Thank you very much. That was a great help and well appreciated.

Sleepindogg

quot;Andyquot; wrote:

gt; Hi
gt;
gt; Use the formula:
gt; =A2amp;B2
gt; If you want a space in between use:
gt; =A2amp;quot; quot;amp;B2
gt; You can then fill this down the column as far as needed. Select the column,
gt; Ctrl C tocopy, then Edit/Paste Special/Values to paste the values in. Then
gt; delete your other two columns.
gt;
gt; Take a backup before you start!
gt;
gt; Andy.
gt;
gt; quot;sleepindoggquot; gt; wrote in message
gt; ...
gt; gt;I am attempting to combine data from two different columns into one column.
gt; gt; Then I want to delete the two columns that I took the data from leaving
gt; gt; only
gt; gt; the combined column data. Can anyone help?
gt;
gt;
gt;

Thiem:

I did the concatenate cell, however, when I deleted the old columns, I lost
everything. It appears that the function was still working between the
cells, therefore, when I deleted the old columns, the new columns were also
lost. Andy sent me a reply that helped me out.

Thanks anyway, your assistance was appreciated.

Sleepindogg

quot;Thiemquot; wrote:

gt;
gt; Colum 1 Colum 2 = Colum 3
gt;
gt; Colum 3 = Concatenate Cell (Colum 2) Cell (Colum2) Copy , then
gt; Paste Value
gt;
gt; If you want a space between data in C1 and C2
gt;
gt; =Concatenate C1 (space) C2
gt;
gt;
gt; cheers
gt;
gt;
gt; --
gt; Thiem
gt; ------------------------------------------------------------------------
gt; Thiem's Profile: www.excelforum.com/member.php...oamp;userid=27474
gt; View this thread: www.excelforum.com/showthread...hreadid=528148
gt;
gt;