Microsoft Office Tutorials and References
In Depth Information
CHAPTER 12 Text Functions
12
CHAPTER
Text Functions
Text Functions Overview
Text functions can be used in several ways. They can return the number of
characters in text strings, remove extra spaces and nonprintable characters
from cells, return exact data within a string, change the case of text strings,
and even combine text from other cells. If you inherit workbooks from other
people, you will eventually run into situations where you have to clean or
manipulate the data. Text functions allow you to create consistency throughout
the workbook. Because certain functions are case-sensitive, it is good practice
to create consistency throughout lists and tables.
The following functions are discussed in this chapter.
ASC
PHONETIC
CHAR
PROPER
CLEAN
REPLACE
CODE
REPT
CONCATENATE
RIGHT
DOLLAR
SEARCH
EXACT
SUBSTITUTE
FIND
T
FIXED
TEXT
JIS
TRIM
LEFT
UPPER
LEN
VALUE
LOWER
YEN
MID
Search JabSto ::




Custom Search