Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Convert Formula to Values after calculation

    I have used a vlookup to retrieve information, now I want the resultant information to stay and remove the formula. How do I do this?

    Kerry

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,175
    Thanks
    47
    Thanked 981 Times in 911 Posts
    Copy the cell then Right click on the cell and select "Paste Values", or "Paste Special".

    cheers, Paul

  3. The Following User Says Thank You to Paul T For This Useful Post:

    kerryg (2014-06-03)

  4. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts
    Too easy!!! Thanks Paul.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •