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, Oct 1, 2013
    #1

    1. Advertisements

  2. lanham01

    Stan Brown Guest

    Copy the data, then Edit » Paste Special » Values to the new
    location.
     
    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.
Similar Threads

  1. Relative to absolute

  2. Absolute cell reference acts like relative

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

  4. Calculate a forecasted increase using a Absolute Ref

  5. Formula - relative or absolute ref, keeps changing

  6. how will i convert 05.01.2007 convert 05.Jan.2007 format?

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

  8. How do I write a formula with absolute cell references

Loading...