Google sheets
From Krm
(Difference between revisions)
(Created page with "=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&B...") |
|||
| (One intermediate revision by one user not shown) | |||
| Line 6: | Line 6: | ||
C1 will show "helloworld" | C1 will show "helloworld" | ||
| + | |||
| + | =How to quote a quote= | ||
| + | use four "s => '"""" | ||
| + | |||
| + | =Date formats= | ||
| + | =TEXT("10-jan-2015","yyyy-mm-dd") -> 2015-01-10 | ||
Latest revision as of 12:04, 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
