concat-two-args |
CONCAT |
=CONCAT("hello", " world") |
value |
1 |
concatenate-with-grid |
CONCATENATE |
=CONCATENATE(A1, A2, A3, "!") |
value |
|
concat-with-numbers |
CONCAT |
=CONCAT("value:", 42) |
value |
1 |
left-with-count |
LEFT |
=LEFT("Sale Price", 4) |
value |
|
left-default |
LEFT |
=LEFT("Sweden") |
value |
|
right-with-count |
RIGHT |
=RIGHT("Sale Price", 5) |
value |
|
right-default |
RIGHT |
=RIGHT("Stock Number") |
value |
|
mid-basic |
MID |
=MID("Romain", 3, 4) |
value |
|
mid-from-start |
MID |
=MID("Romain", 1, 2) |
value |
|
mid-beyond-end |
MID |
=MID("Romain", 3, 6) |
value |
|
mid-start-0 |
MID |
=MID("Romain", 0, 3) |
value |
2 |
mid-negative-count |
MID |
=MID("Romain", 1, -1) |
value |
|
len-basic |
LEN |
=LEN("Phoenix, AZ") |
value |
|
len-empty |
LEN |
=LEN("") |
value |
|
len-with-spaces |
LEN |
=LEN(" One") |
value |
|
lower |
LOWER |
=LOWER("E. E. Cummings") |
value |
|
upper |
UPPER |
=UPPER("total") |
value |
|
upper-mixed |
UPPER |
=UPPER("Yield") |
value |
|
trim |
TRIM |
=TRIM(" First Quarter Earnings ") |
value |
1 |
substitute-basic |
SUBSTITUTE |
=SUBSTITUTE("hello world", "world", "earth") |
value |
|
substitute-multiple-occurrences |
SUBSTITUTE |
=SUBSTITUTE("abcabc", "a", "x") |
value |
|
substitute-specific-instance |
SUBSTITUTE |
=SUBSTITUTE("abcabc", "a", "x", 2) |
value |
|
find-case-sensitive |
FIND |
=FIND("M", "Miriam McGovern") |
value |
|
find-lowercase |
FIND |
=FIND("m", "Miriam McGovern") |
value |
|
find-with-start |
FIND |
=FIND("M", "Miriam McGovern", 3) |
value |
|
find-not-found |
FIND |
=FIND("B", "Miriam McGovern") |
value |
|
exact-match |
EXACT |
=EXACT("word", "word") |
value |
1 |
exact-case-differs |
EXACT |
=EXACT("Word", "word") |
value |
1 |
replace-basic |
REPLACE |
=REPLACE("abcdefghijk", 6, 5, "*") |
value |
1 |
replace-year |
REPLACE |
=REPLACE("2009", 3, 2, "10") |
value |
1 |
rept-basic |
REPT |
=REPT("ha", 3) |
value |
1 |
rept-zero |
REPT |
=REPT("ha", 0) |
value |
|
textjoin-comma-separator |
TEXTJOIN |
=TEXTJOIN(", ", TRUE, A1:A3) |
value |
1 |
textbefore-space |
TEXTBEFORE |
=TEXTBEFORE("Brian Wiles", " ") |
value |
1 |
textbefore-second-instance |
TEXTBEFORE |
=TEXTBEFORE("one,two,three", ",", 2) |
value |
1 |
textafter-space |
TEXTAFTER |
=TEXTAFTER("Brian Wiles", " ") |
value |
1 |
textafter-second-instance |
TEXTAFTER |
=TEXTAFTER("one,two,three", ",", 2) |
value |
1 |