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?

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.
Similar Threads
  1. tghcogo

    Relative to absolute

    tghcogo, Jun 21, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    97
    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:
    213
  3. Marc G
    Replies:
    2
    Views:
    115
    Alan Beban
    Jan 5, 2005
  4. Project
    Replies:
    0
    Views:
    101
    Project
    Feb 22, 2005
  5. Marc
    Replies:
    5
    Views:
    114
    zackb
    Apr 26, 2005
  6. Hoib
    Replies:
    4
    Views:
    144
    Debra Dalgleish
    Jul 23, 2005
  7. Tan
    Replies:
    0
    Views:
    83
  8. deb44
    Replies:
    3
    Views:
    236
    Billy Liddel
    Feb 5, 2010
Loading...