Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 1st 13, 08:29 PM
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?

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

Hi,

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


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Old October 2nd 13, 09:54 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 524
Default Convert Formula Results to Absolute

On Tue, 1 Oct 2013 20:29:36 +0100, lanham01 wrote:

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 data, then Edit* Paste Special* Values to the new
location.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert selected formula references from relative to absolute M Excel Discussion (Misc queries) 6 March 24th 10 01:09 AM
Turning forumula results as absolute numbers Edward Excel Discussion (Misc queries) 4 January 16th 08 06:22 PM
How do I convert formula result into numbers so I can sum results? Barsha Excel Discussion (Misc queries) 1 November 11th 06 07:18 PM
How can I convert a formula to it's results? ZBC2 Excel Discussion (Misc queries) 9 January 29th 06 02:17 PM
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? Fernando Excel Discussion (Misc queries) 1 December 1st 05 05:02 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017