Can you prepare the text or concentrate before you have data. I teach children and I want them to fill in sections and then it appears into another cell once they fill it in. So the only thing that they have is my instructions, then they fill it in and a summary appears. How can I do this please
Hi Deborah! Yes, you can enter the formula in the cell where you want the output even before any data is in the source cells. If you want text from cells A1, D1, and E1 to be displayed as a single item in cell H1 for example, then you can go to H1 and type =A1&D1&E1 If you use the above method, remember that there will be no spaces between the values unless you insert them into the formula too, like this: =A1&" "&D1&" "&E1. If you have lots of values, the TEXTJOIN function might be more efficient. After you enter the formula, the cell will appear blank since there is nothing in the source cells yet, but when they do get populated with data, it will be displayed in your output cell.
Super!
Can you prepare the text or concentrate before you have data. I teach children and I want them to fill in sections and then it appears into another cell once they fill it in. So the only thing that they have is my instructions, then they fill it in and a summary appears. How can I do this please
Hi Deborah! Yes, you can enter the formula in the cell where you want the output even before any data is in the source cells. If you want text from cells A1, D1, and E1 to be displayed as a single item in cell H1 for example, then you can go to H1 and type
=A1&D1&E1
If you use the above method, remember that there will be no spaces between the values unless you insert them into the formula too, like this: =A1&" "&D1&" "&E1. If you have lots of values, the TEXTJOIN function might be more efficient. After you enter the formula, the cell will appear blank since there is nothing in the source cells yet, but when they do get populated with data, it will be displayed in your output cell.