View Single Post
  #1   Report Post  
Old October 1st 13, 08:29 PM
lanham01 lanham01 is offline
Junior Member
 
First recorded activity by ExcelBanter: Oct 2013
Posts: 1
Default Convert Formula Results to Absolute

I merged First Name and Last Name columns to a Full Name column with a formula. I want to copy/paste the Full Name column to another spreadsheet without having to reference the First and Last Name columns. Is there a way to eliminate the formula references in the Full Name column and retain the results?