New Problem: #REF!

B

Baylynx

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?
 
B

Baylynx

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!
 
J

JLatham

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.
 
Top