Okay, I succeeded in combining the first and last names from two separate
columns into a new third column. However, when I try to delete the unwanted
first and last name columns, all the data in the Full Name column is replaced
with #REF!

What can I do? Is there any way I can unlink these three columns?

Select whole 3rd column
EditCopy
EditPaste special , check Values

HTH
--
AP

"Baylynx" a écrit dans le message de
news: ...
Okay, I succeeded in combining the first and last names from two separate
columns into a new third column. However, when I try to delete the
unwanted
first and last name columns, all the data in the Full Name column is
replaced
with #REF!

What can I do? Is there any way I can unlink these three columns?

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553853

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

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

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