+ Reply to Thread
Results 1 to 9 of 9

Copying value from a cell with a formula.

  1. #1
    Registered User
    Join Date
    06-29-2020
    Location
    NC
    MS-Off Ver
    Online
    Posts
    5

    Copying value from a cell with a formula.

    I want to use the 'Copy' to get the text that is in a cell. But the text is the product of a formula within the cell. So that when the 'Copy' is used, the 'Paste' then puts the formula instead of the value. Is there anyway to do this?

    Mjj4golf1

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    5,738

    Re: Copying value from a cell with a formula.

    Try the FORMULARTEXT function

  3. #3
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    713

    Re: Copying value from a cell with a formula.

    Or use Paste Special>Values
    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    06-29-2020
    Location
    NC
    MS-Off Ver
    Online
    Posts
    5

    Re: Copying value from a cell with a formula.

    I'm not looking for the formula to be the text, but the result of the formula.

  5. #5
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    713

    Re: Copying value from a cell with a formula.

    Yes, so do the Copy, then Paste Special>Values

  6. #6
    Registered User
    Join Date
    06-29-2020
    Location
    NC
    MS-Off Ver
    Online
    Posts
    5

    Re: Copying value from a cell with a formula.

    Gregb11
    Thanks and that does work. But is there a way to do it without manually doing a
    copy/paste?
    .

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: Copying value from a cell with a formula.

    You can record a macro or use this bit of code:

    Please Login or Register  to view this content.
    I have this attached to a button.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  8. #8
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,704

    Re: Copying value from a cell with a formula.

    If you just want to convert a formula to a value in the SAME cell then a sheet event macro would seem the most obvious. e.g.

    Please Login or Register  to view this content.
    If you want it to apply across all sheets then use instead the Workbook_SheetBeforeDoubleClick() event.

    Personally I think as Greg has suggested a copy and paste values - using shortcuts is just as easy. i.e.

    Ctrl-C, followed by Alt-e, s, v
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: Copying value from a cell with a formula.

    Thanks for the rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying formula result to new cell, without copying formula itself
    By nappyjim1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2016, 02:24 AM
  2. Replies: 1
    Last Post: 02-03-2015, 06:44 AM
  3. [SOLVED] Retaining formula cell references when copying a formula to a different cell
    By FrankParisi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2013, 07:05 AM
  4. [SOLVED] copying cell without removing formula from the cell i copied from
    By raffi123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2013, 10:09 AM
  5. Replies: 1
    Last Post: 04-06-2013, 12:22 AM
  6. Replies: 7
    Last Post: 10-31-2012, 05:21 AM
  7. Copying cell value with formula
    By pal_slg in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-24-2011, 02:39 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1