Obedenenie cells in Google Spreadsheets?

0 like 0 dislike
13 views
How to merge two cells into one cell with the proviso that this is one cell will change its value depending on the changes of those two. And whether it is possible such to implement?
by | 13 views

2 Answers

0 like 0 dislike
Merge cells and formulas of those cells.
For example, if the formula in A1 =TEXT(TODAY(), "mm/dd/yy")
and in A2 =TEXT(NOW(), "hh:MM:ss")
the final formula in the merged cell:
=TEXT(TODAY(), "mm/dd/yy") & CHAR(10) & TEXT(NOW(), "hh:MM:ss")
by
0 like 0 dislike
In cell C2 write:
=A2&B2
by
110,608 questions
257,186 answers
0 comments
33,685 users