Skip to search results
PRODUCT
Office.com results
FIND, FINDB
Article FIND and FINDB locate one text string within a second text string, and return the number of the starting position of the first text string from the first charac...
Excel 2003
EXACT
Article Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT ...
Excel 2003
FIXED
Article Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax FIXE...
Excel 2003
SUBSTITUTE
Article Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace...
Excel 2003
LOWER
Article Converts all uppercase letters in a text string to lowercase. Syntax LOWER ( text ) Text   is the text you want to convert to lowercase. LOWER does not change c...
Excel 2003
DOLLAR
Article The function described in this Help topic converts a number to text format and applies a currency symbol. The name of the function (and the symbol that it appli...
Excel 2003
MID, MIDB
Article MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. MIDB return...
Excel 2003
PHONETIC
Article Extracts the phonetic (furigana) characters from a text string. Syntax PHONETIC ( reference ) Reference   is a text string or a reference to a single cell or a ...
Excel 2003
SEARCH, SEARCHB
Article Find one text string's starting position within another text string in Excel 2003.
Excel 2003
RIGHT, RIGHTB
Article RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns the last character or characters ...
Excel 2003
REPT
Article Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. Syntax REPT ( text , number_times ) Text   is the tex...
Excel 2003
JIS
Article The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name o...
Excel 2003
REPLACE, REPLACEB
Article REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. REPLACEB replaces part of a text string, ba...
Excel 2003
LEN, LENB
Article LEN returns the number of characters in a text string. LENB returns the number of bytes used to represent the characters in a text string. Important LEN i...
Excel 2003
ASC
Article For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax ASC ( text ) Text   ...
Excel 2003
LEFT, LEFTB functions
Article Use the LEFT and LEFTB functions to help remove unwanted characters in Excel 2003.
Excel 2003
CODE
Article Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. Operating environment...
Excel 2003
T
Article Returns the text referred to by value. Syntax T ( value ) Value   is the value you want to test. Remarks If value is or refers to text, T returns value. If valu...
Excel 2003
CHAR
Article Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Opera...
Excel 2003
Text and Data functions
Article Text functions Function Description ASC Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) chara...
Excel 2003
TRIM function
Article Remove all spaces from text except for single spaces between words in Excel 2003.
Excel 2003
PROPER
Article Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowerca...
Excel 2003
UPPER
Article Converts text to uppercase. Syntax UPPER ( text ) Text   is the text you want converted to uppercase. Text can be a reference or text string. Example The exampl...
Excel 2003
BAHTTEXT
Article Converts a number to Thai text and adds a suffix of "Baht." In Microsoft Excel for Windows, you can change the Baht format to a different style by using Region...
Excel 2003
VALUE
Article Converts a text string that represents a number to a number. Syntax VALUE ( text ) Text   is the text enclosed in quotation marks or a reference to a cell conta...
Excel 2003
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com