Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
Guru Tip: If you have kids in middle school math, they can check their homework
using this function.
LEFT(text,num_chars) [Category: Text]
LEFT returns the ﬁ rst character or characters in a text string, based on the
number of characters you specify. Guru Tip: In the image below, the item #
predictably has a 3 character preﬁ x. To isolate the preﬁ x, use =LEFT(A4,3). To
get the number after the dash, use =MID(A4,5,3) or =RIGHT(A4,3).
If the dash does not reliably occur in the 4th position in every value, use FIND to
locate the position of the dash and then subtract 1: =LEFT(F4,FIND("-",F4)-1
LEFTB(text,num_bytes) [Category: Text]
LEFTB returns the ﬁ rst character or characters in a text string, based on
the number of bytes you specify. This function is for use with double-byte
characters.
LEN(text) [Category: Text]
LEN returns the number of characters in a text string. Guru Tip: See an example
under RIGHT where LEN is used in conjunction with RIGHT.
LENB(text) [Category: Text]
LENB returns the number of bytes used to represent the characters in a text
string. This function is for use with double-byte characters.

Search JabSto ::

Custom Search