•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to COPY as value (rather than paste)?
Our take
Are you tired of the tedious process of copying and pasting values from complex formulas? If your workflow involves frequently converting formulas into static text, you're not alone. Fortunately, there are efficient methods to streamline this process directly from your original cell. Instead of using a helper cell, you can utilize keyboard shortcuts or advanced features that allow you to copy values instantly. This guide will explore these techniques, helping you save time and enhance your productivity.
In A1 I have a complex formula involving CONCAT from many cells leading to a long string.
I need to use this as text (paste the text as part of another cell which is comments, that is, where I want to paste is not a formula).
Currently I copy A1, paste as values in helper cell A2. And then select the text in A2 and copy it.
Is there a faster way to copy only values from a cell (A1) directly? I need to do this several times a day.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience