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

Related questions

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
33,685 users