Google sheets
From Krm
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"
How to quote a quote
use four "s => '""""
Date formats
=TEXT("10-jan-2015","yyyy-mm-dd") -> 2015-01-10