LEN
|
Form
|
Where
|
Result
|
|---|---|---|
|
LEN(x)
|
x is text
|
A number
|
Description
Tells you the length of a piece of text. Note that spaces count.
|
Example
|
Result
|
|---|---|
|
=LEN("Mobile Forms")
|
12
|
UPPER
|
Form
|
Where
|
Result
|
|---|---|---|
|
UPPER(x)
|
x is text
|
Text
|
Description
Converts to uppercase.
|
Example
|
Result
|
|---|---|
|
=UPPER("Mobile Forms")
|
"MOBILE FORMS"
|
LOWER
|
Form
|
Where
|
Result
|
|---|---|---|
|
LOWER(x)
|
x is text
|
Text
|
Description
Converts to lowercase.
|
Example
|
Result
|
|---|---|
|
=LOWER("Mobile Forms")
|
"mobile forms"
|
TRIM
|
Form
|
Where
|
Result
|
|---|---|---|
|
TRIM(x)
|
x is text
|
Text
|
Description
Removes all spaces except the single spaces between words.
|
Example
|
Result
|
|---|---|
|
=TRIM(" Mobile Forms ")
|
"Mobile Forms"
|
REPT
|
Form
|
Where
|
Result
|
|---|---|---|
|
REPT(x, n)
|
x is text
n is a number |
Text
|
Description
Repeats x n times.
|
Example
|
Result
|
|---|---|
|
=REPT("-", 4)
|
"----"
|
SUBSTITUTE
|
Form
|
Where
|
Result
|
|---|---|---|
|
=SUBSTITUTE(x, y, z)
|
x is text
y is text z is text |
Text
|
Description
Replaces all occurrences of y in x with z.
|
Example
|
Result
|
|---|---|
|
=SUBSTITUTE("loonie toon", "oo", "u")
|
"lunie tun"
|
FIND
|
Form
|
Where
|
Result
|
|---|---|---|
|
FIND(x, y, n)
|
x is text
y is text n is a number |
A number
|
Description
The result is the location of the first occurance of x in y, after the nth character, or zero if x does not appear in y.
n is treated as 1 if it is less than 1 (the first character).
Result is always zero if n is greater than the length of y, since x will never apper after the end.
n is treated as 1 if it is less than 1 (the first character).
Result is always zero if n is greater than the length of y, since x will never apper after the end.
|
Example
|
Result
|
|---|---|
|
=FIND("oo", "loonie toon", 1)
|
2
|
|
=FIND("oo", "loonie toon", 2)
|
2
|
|
=FIND("oo", "loonie toon", 3)
|
1
|
|
=FIND("oo", "loonie toon", 10)
|
0
|
|
=FIND("u", "loonie toon", 1)
|
0
|