February 17, 2026•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)?

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.

Check out the full article on the original site

#AI formula generation techniques

#rows.com

#Excel compatibility

#Excel alternatives for data analysis

#copy

#paste

#value

#formula

#CONCAT

#cell

#text

#long string

#helper cell

#A1

#A2

#comments

#faster way

#select

#submitted by

#reddit