Obedenenie cells in Google Spreadsheets?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
16 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 | 16 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
35,456 users