28 апр. 2014 г. · You can use the string concatenation operator, & : =IF(A1>A2, "value is " & C5, "value is " & D5). This is equal to, but less verbose than:

15 мар. 2022 г. · This isn't possible in Google Sheets. You'd have to manually recreate the number format in your formula. Typically, you'd use the TEXT function.

20 янв. 2015 г. · I want to know how I can take a string literal such as "Paper " and concatenate it to the string of characters as they appear in another cell using a formula.

6 нояб. 2020 г. · I am looking to insert two cell values into one cell, one following the other. For the following example see the Image below.

21 февр. 2014 г. · 1 : Open a Google spreadsheet->Rightclick a cell->Insert Note. I want data from, say A1 a string "Moo", to link into another cell, B1, so B1 has a note ...

17 февр. 2014 г. · Try: =indirect(E26&"!"&$AV$6) Indirect is able to read a string as a cell reference. Within the parentheses three elements are concatenated.

29 апр. 2019 г. · In Google Sheets, when referring to another worksheet in a formula, is there a way to insert the text value of a cell as the name of the sheet to be referenced?

13 сент. 2012 г. · You need to create the URL with a formula in one cell, then use the HYPERLINK function in another cell, referencing the created URL.

11 нояб. 2023 г. · I currently have a spreadsheet which requires a variable number of line breaks within a cell based on input data from another cell.

28 мая 2019 г. · I would like to add text that begins with an equal sign in a cell but I get the following error: #NAME? Question: How can I set a cell's text to ...