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?