Microsoft Office Tutorials and References
In Depth Information
Syntax
When a customer comes in to buy a part, he probably doesn t care about the
vendor. So the real question is, Do you have anything in stock that can fix
my problem?
Excel offers three functions LEFT, MID, and RIGHT that allow you to
isolate just the first or just the last characters, or even just the middle
characters, from a column.
Syntax
=LEFT(text,num_chars)
The LEFT function returns the first character or characters in a text
string, based on the number of characters specified. This function takes the
following arguments:
text
text This is the text string that contains the characters you want
to extract.
num_chars
num_chars This specifies the number of characters you want LEFT
to extract. num_charsmust be greater than or equal to zero. If
num_charsis greater than the length of text, LEFT returns all of
text. If num_charsis omitted, it is assumed to be 1.
Syntax
=RIGHT(text,num_chars)
The RIGHT function returns the last character or characters in a text
string, based on the number of characters specified. This function takes the
following arguments:
text
text This is the text string that contains the characters you want
to extract.
num_chars
num_chars This specifies the number of characters you want
RIGHT to extract. num_charsmust be greater than or equal to zero. If
num_charsis greater than the length of text, RIGHT returns all of
text. If num_charsis omitted, it is assumed to be 1.
Syntax:
=MID(text,start_num,num_chars)
Search JabSto ::




Custom Search