Google sheets

From Krm
(Difference between revisions)
Jump to: navigation, search
(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 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
Personal tools