New Problem: #REF!

[Guest]

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?

 

[Ardus Petus]

Select whole 3rd column
Edit>Copy
Edit>Paste special , check Values

HTH

 

[Bearacade]

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

 

[Gord Dibben]

Just paste special in place.

Why add another column?


Gord Dibben MS Excel MVP

 

[Guest]

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 edit>copy>paste special. Then when I try
to delete columns A and B, column C reverts to #REF!

 

[Guest]

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.