V
V
Vlad Zhbankov2018-05-02 16:28:24
Google Sheets
Vlad Zhbankov, 2018-05-02 16:28:24

How to merge cells in Google Sheets?

How to merge two cells into one with the condition that this very one cell will change its value depending on the changes in those two? And is it even possible to do this?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
lvv85, 2018-05-03
@lvv85

Merge cells and formulas of these cells.
For example, if the formula is in A1 and in A2, then the resulting formula in the merged cell is: =TEXT(TODAY(), "mm/dd/yy") & CHAR(10) & TEXT(NOW(), "hh:MM:ss") =TEXT(TODAY(), "mm/dd/yy")

A
Aleksandr, 2018-05-03
@alexgearbox

In cell C2 we write:
=A2&B2

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question