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
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
Try the FORMULARTEXT function
Quang PT
Or use Paste Special>Values
I'm not looking for the formula to be the text, but the result of the formula.
Yes, so do the Copy, then Paste Special>Values
Gregb11
Thanks and that does work. But is there a way to do it without manually doing a
copy/paste?
.
You can record a macro or use this bit of code:
I have this attached to a button.Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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.
If you want it to apply across all sheets then use instead the Workbook_SheetBeforeDoubleClick() event.Please Login or Register to view this content.
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
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks