Copying value from a cell with a formula.

[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

[bebo021999]

Try the FORMULARTEXT function

[Gregb11]

Or use Paste Special>Values

[mjj4golf1]

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

[Gregb11]

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

[mjj4golf1]

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

[AliGW]

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.

[Richard Buttrey]

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

[AliGW]

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.