It should work. Select all of the cells in column C where you combined them
with the formula. Use copy at that point. Without unselecting them, simply
use Edit | Paste Special and make sure [Values] is selected and press OK.
You should then be able to delete columns A and B.

I think we are all presuming you used a formula something like this in
column C:
=A1 & " " & B1
or
=B1 & ", " & A1

If you used something else, please copy the formula and show it to us here.

"Baylynx" wrote:

Hey folks,

Paste Special is not working for me. I select the new column C created with
data from column A and B. I select editcopypaste special. Then when I try
to delete columns A and B, column C reverts to #REF!

"Gord Dibben" wrote:

Just paste special in place.

Why add another column?


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 18:00:05 -0500, Bearacade
wrote:


Yeah.. copy the third Column and paste special value into a fourth
column