Google sheets
From Krm
(Difference between revisions)
(→Ideas to concatenate contents from multiple fields.) |
|||
| Line 9: | Line 9: | ||
=How to quote a quote= | =How to quote a quote= | ||
use four "s => '"""" | use four "s => '"""" | ||
| + | |||
| + | =Date formats= | ||
| + | =TEXT("10-jan-2015","yyyy-mm-dd") -> 2015-01-10 | ||
Latest revision as of 17:49, 14 July 2015
[edit] Ideas to concatenate contents from multiple fields.
You can concatenate contents from multiple fields by joining fields with '&' operator.
A1 hello B1 world C1 =A1&B1
C1 will show "helloworld"
[edit] How to quote a quote
use four "s => '""""
[edit] Date formats
=TEXT("10-jan-2015","yyyy-mm-dd") -> 2015-01-10
