Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert selected formula references from relative to absolute | Excel Discussion (Misc queries) | |||
Turning forumula results as absolute numbers | Excel Discussion (Misc queries) | |||
How do I convert formula result into numbers so I can sum results? | Excel Discussion (Misc queries) | |||
How can I convert a formula to it's results? | Excel Discussion (Misc queries) | |||
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) |