Google sheets

From Krm
Revision as of 12:04, 14 July 2015 by Keshav (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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