Page 269 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 255

EXCEL FUNCTION QUICK REFERENCE B

TEST FUNCTIONS

FUNCTION DESCRIPTION
BAHTEXT(number) Converts a number to Thai.
CHAR(number) Returns the specified character value.
CLEAN(text) Removes all nonprintable characters from text.
CODE(text) Finds the character code for the first character in a text string.
CONCATENATE(text1, text2, ...) Joins the specified text strings.
DOLLAR(number[, decimals]) Converts a number to a currency value.
EXACT(text1, text2) Determines if two strings are the same.
FIND(find_text, within_text[, start_num]) Locates one text string within another text string.
FIXED(number[, decimals, no_commas]) Rounds a number to the specified number of decimal places.
LEFT(text[, num_chars]) Returns the specified number of characters from the left side
of a text string.
LEN(text) Finds the length of a text string.
LOWER(text) Converts a string to lowercase characters.
MID(text, start_num, num_chars) Returns the specified number of characters from the center of
the text string.
PROPER(text) Capitalizes the first character in a string and converts the
remaining characters to lowercase.
REPLACE(old_text, start_num, num_chars, new_text) Replaces text at the specified location with the new text.
REPT(text, number_times) Repeats a text string the specified number of times.
RIGHT(text[, num_chars]) Returns the specified number of characters from the right
side of a text string.
SEARCH(find_text, within_text[, start_num]) Determines the starting position of one text string within
another text string.
SUBSTITUTE(text, old_text, new_text[, Replaces the specified text within a string.
instance_num])
T(value) Returns the specified value.
TEXT(value, format_text) Converts a value to the text with the specified format.
TRIM(text) Removes all extra spacing from a text string.
UPPER(text) Converts all letters in a string to uppercase.
VALUE(text) Converts a text string to a number.

255