View Single Post
  #2   Report Post  
Old October 1st 13, 08:51 PM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,669
Default Convert Formula Results to Absolute


Am Tue, 1 Oct 2013 20:29:36 +0100 schrieb lanham01:

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?

copy the column and then paste special = paste values

Claus B.
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2