ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Convert Formula Results to Absolute (https://www.excelbanter.com/new-users-excel/449318-convert-formula-results-absolute.html)

lanham01 October 1st 13 08:29 PM

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?

Claus Busch October 1st 13 08:51 PM

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

Stan Brown October 2nd 13 09:54 AM

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...


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com