Table of Contents
Advertisement
Function
LEFT (string,
hum)
Description
Returns
the characters
in the leftmost
position
in a string. Num is the number
of
characters
to return. The first character
in the string is in position O. A reference
to
cells containing
values produces
an error. The RIGHT function extracts characters
beginning
with the rightmost
character,
while LEFT extracts beginning
with the
leftmost character,
and MID extracts from an internal position.
See the descriptions
of
the RIGHT and MID functions.
LENGTH
(string)
Returns
the number
of characters
in a string
including
characters,
punctuation
,
marks,
and spaces
enclosed
in quotation
marks.
Converts
uppercase
characters
to lowercase.
LOWER (sUing)
MID (s_ng, start,
ttum)
PROPER (string)
REPEAT
(string,
tzum)
REPLACE (original,
start,
hum,
l_eplace)
RIGHT (string,
hum)
Returns
the
number
of characters
(hum)
in the
middle
of a string,
beginning
at
the position
you indicate
(start).
The first character
in the string
is in position
0. A
reference
to cells containing
values
produces
an error. The RIGHT
function
extracts
characters
beginning
with the rightmost
character,
LEFT extracts
beginning
with
the
: leftmost
character,
and MID extracts
from
an internal
position.
For more
information,
] see the descriptions
of the LEFT and
RIGHT
functions.
CapitaliT_es the first letter of every word and the first letter following any nonletter
character.
PROPER converts all other characters
to lowercase.
Repeats
a string a specified
number of times. If nton is zero, REPEAT returns an
empty string. For example,
REPEAT("HA",6) returns HaHaHaHaHaHa.
Replaces
matching
characters
in a string
with
a specified
string.
On_ina/is
the text
string
in which
you want
to replace
chara_ers.
Start
is the first character
in the
original-string
that.-you_c'a%xt- to replace.
The first character
in the string
is 0. ?rum
is
the number
of characters
in the original
string
that
you want
to replace.
Replace
is the
replacement
string.
You can use more
or fewer
replacement
characters
than
are
replaced,
in the original
string.
Returns
the
characters
in the
rightmost
position
in a string.
RIGHT
returns to the
right
that number
of leftmost
characters.
The first character
in the string
is in position
0. A reference
to cells containing
values
produces
an error.
While
RIGHT
extracts
characters
beginning
with
the rightmost
character,
LEFT extracts
beginning
with
the
leftmost
character,
and MID extracts
from
an internal
position.
For more
information,
see the descriptions
of the LEFT and MID functions.
STRING
(value,
N)
Converts
values
to a string
using
N decimal
places.
N can be a number
from
0
through
15. For example,
STRING(245.356,1)
returns
245.4.
TRIM
(string)
Removes
extra
spaces
before
and
after words
and between
lines of text in a string.
UPPER
(string)
Converts
a string
to uppercase..
VALUE
(string)
Converts
a number
in string
form
to a value
Appendix
225
Advertisement
Table of Contents
