Thursday 15 July 2010

Text function in excel 2003

Based on data from 2003 excel offline help, there are some text functions such as: 

ASC Changes full-width (double-byte) Bahasa letters or katakana within a character string to half-width (single-byte) characters
BAHTTEXT converts a number to text, using the ß (baht) currency format
CHAR Returns the character specified by the code number
CLEAN Removes all characters from a text nonprintable
CODE Returns a numeric code for the first character in a text string
Trust Joins CONCATENATE text items into one text item
DOLLAR converts a number to text, using the $ (dollar) currency format
EXACT checks to see if two text values are identical
FIND Finds one text value within another (case sensitive)
FIXED Formats a number as text with a fixed number of decimals
JIS Changes half-width (single-byte) Bahasa letters or katakana within a character string to a full-width (double-byte) characters


LEFT Returns the leftmost characters from a text value

LEN Returns the number of characters in a text string
LOWER converts text to lowercase
MID Returns a specific number of characters from a text string starting at the position you Specify
Phonetic extracts the phonetic (Furigana) characters from a text string
PROPER Capitalizes the first letter in Each word of a text value
REPLACE Replaces characters within text
REPT repeats text a given number of times
RIGHT Returns the rightmost characters from a text value
SEARCH Finds one text value within another (not case-sensitive)
Substitute substitutes new text for old text in a text string
T converts its arguments to text
TEXT Formats a number and converts it to text
TRIM Removes spaces from text
UPPER converts text to uppercase
VALUE converts a text argument to a number

Related Posts by Categories



No comments:

Post a Comment

Random Posts