Google sheets

From Krm
Jump to: navigation, search

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
Personal tools