I have a file with a concatenate formula, since I will share this file, I don’t want people to struggle when they will copy the text (I suppose some of them will try to double click on the formula cell and see it, it is not what I want).
What I am trying to do is to automatically convert the cell formula into a text so it appears as if someone just write a text in a cell without any formula.
I don’t have experience with google script but I assume it is possible ?
Here is a file example :
https://docs.google.com/spreadsheets/d/1Xs4GGdpueWaUSjrLrjZp1V_jCac6gNIl_kyTLqmDWD0/edit?usp=sharing
I tryed to use the TEXT function but it endend the same, unless it is possible to have like : a formula in a column that I hide that will send the result in the right column
Manahge is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.