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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tghcogo

    Relative to absolute

    tghcogo, Jun 21, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    75
    tghcogo
    Jun 22, 2004
  2. Top Spin

    Absolute cell reference acts like relative

    Top Spin, Nov 6, 2004, in forum: Excel Beginners
    Replies:
    5
    Views:
    186
  3. Marc G
    Replies:
    2
    Views:
    90
    Alan Beban
    Jan 5, 2005
  4. Project
    Replies:
    0
    Views:
    81
    Project
    Feb 22, 2005
  5. Marc
    Replies:
    5
    Views:
    89
    zackb
    Apr 26, 2005
  6. Hoib
    Replies:
    4
    Views:
    116
    Debra Dalgleish
    Jul 23, 2005
  7. Tan
    Replies:
    0
    Views:
    63
  8. deb44
    Replies:
    3
    Views:
    132
    Billy Liddel
    Feb 5, 2010
Loading...