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:
    91
    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:
    206
    Max
    Nov 6, 2004
  3. Marc G

    Link to a cell in another workbook by name rather than absolute c.

    Marc G, Jan 5, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    108
    Alan Beban
    Jan 5, 2005
  4. Project

    Calculate a forecasted increase using a Absolute Ref

    Project, Feb 22, 2005, in forum: Excel Beginners
    Replies:
    0
    Views:
    94
    Project
    Feb 22, 2005
  5. Marc

    How/can you create absolute values for cell references that have sum(a1:a4)?

    Marc, Apr 26, 2005, in forum: Excel Beginners
    Replies:
    5
    Views:
    107
    zackb
    Apr 26, 2005
  6. Hoib

    Formula - relative or absolute ref, keeps changing

    Hoib, Jul 22, 2005, in forum: Excel Beginners
    Replies:
    4
    Views:
    134
    Debra Dalgleish
    Jul 23, 2005
  7. Tan

    Input formulas in a defined data range and convert results as valu

    Tan, Apr 18, 2007, in forum: Excel Beginners
    Replies:
    0
    Views:
    77
    Tan
    Apr 18, 2007
  8. deb44

    How do I write a formula with absolute cell references

    deb44, Feb 3, 2010, in forum: Excel Beginners
    Replies:
    3
    Views:
    228
    Billy Liddel
    Feb 5, 2010
Loading...