View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default New Problem: #REF!

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?