Convert Formula Results to Absolute

Discussion in 'Excel Beginners' started by lanham01, Oct 1, 2013.

  1. lanham01

    lanham01 Guest

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


    --
    lanham01
     
    lanham01, Oct 1, 2013
    #1
    1. Advertisements

  2. lanham01

    Stan Brown Guest

    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...
     
    Stan Brown, Oct 2, 2013
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.