How can I convert a function cell into a string automatically?
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.
How can I do this?
Here is a file example. 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.
Your file can't be accessed. But you can use the hidden column with a formula like this:
=HSTACK("Put anything here",YOUR FORMULA)
For example, the formula would be put in A1, and say "Put anything here" in the A1 and the result of the formula in B1:
See what I get in B1:
- Appscript Google sheets returns null
- Conditional formatting if a cell is a duplicate value
- Google Sheets Image() function now requires users to hit Allow Access
- Can I use Google Apps Script instead of Formulas for doing calculations on a spreadsheet?
- Is it possible to display an iframe or webview in google sheets
- In the same Google Sheet Workbook, can you extract the info from a cell in Sheet A to a cell in Sheet B, and link it back to the same cell in Sheet A?
- GSPREAD bulk export of dataframes on separate sheets without triggering API write request limits
- How do I configure Apps Script time-based Triggers to execute successfully?
- Write the count files in folder to a spreadsheet
- Adding message to email when using addEditor()
- Spreadsheet formulas calculation control
- Is there a way to keep two sheets synchronized?
- How to generate an uuid in google sheet?
- Google Sheets calculate percentage of the values in the rightmost column of total values in that column
- Struggling to set an option in a google Sheet's dropdown menu with JS
- How to perform calculations on numbers stored as text in google sheets or excel?
- Can't use getValues() with IMPORTRANGE
- How can turn this sumif into an arrayformula in Google Sheets?
- How can I retrieve the hyperlink from a data cell in google apps script?
- Email Google Sheets table and preserve link formatting
- Sheets countifs function returning 0 value
- Countif count Sunday to Friday correctly until it reach Saturday in google sheets
- How to get a bill to populate with the amount, only if the particular payday falls exactly on or 6 days before the due date?
- Google Sheets - Import Range issue and building a formula that both Import Ranges but based on corresponding Data Validation in another column
- How can I match a smart chip using SUMIF?
- Google Sheets - Bypassing the restriction of 50k characters for TEXTJOIN
- Customized FOrmel in google sheets to mark the current calendar week of the current year
- How to auto repeat ImportHTML with multiple URLS in Google Sheets
- How do I use IFS to conditionally apply a percentage?
- Import of a Large Quantity of API Data