Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Text Functions
Function |
Description |
Syntax |
||
ASC |
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
(text) |
||
BAHTTEXT |
Converts a number to text, using the baht currency format |
(number) |
||
CHAR |
Returns the character specified by the code number |
(number) |
||
CLEAN |
Removes all nonprintable characters from text |
(text) |
||
CODE |
Returns a numeric code for the first character in a text string |
(text) |
||
CONCATENATE |
Joins several text items into one text item |
(text1,text2,...) |
||
DOLLAR |
Converts a number to text, using the $ (dollar) currency format |
(number,decimals) |
||
EXACT |
Checks to see if two text values are identical |
(text1,text2) |
||
FIND (FINDB) |
Locates one text value within another (case-sensitive) |
(find_text,within_text,start_num) |
||
FIXED |
Formats a number as text with a fixed number of decimals |
(number,decimals,
no_commas) |
||
JIS |
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
(text) |
||
LEFT |
Returns the leftmost characters from a text value based on a number of characters you specify |
(text,num_chars) |
||
LEFTB |
Returns the leftmost characters from a text value based on a number of bytes you specify |
(text,num_bytes) |
||
LEN |
Returns the number of characters in a text string |
(text) |
||
LENB |
Returns the number of bytes used to represent characters in a text string. |
(text) |
||
LOWER |
Converts text to lowercase |
(text) |
||
MID |
Returns a specific number of characters from a text string starting at the position that you specify, based on the number of characters that you specify |
(text,start_num,
num_chars) |
||
MIDB |
Returns a specific number of characters from a text string starting at the position that you specify, based on the number of bytes that you specify |
(text,start_num,
num_chars) |
||
PHONETIC |
Extracts the phonetic (furigana) characters from a text string |
(reference) |
||
PROPER |
Capitalizes the first letter in each word of a text value |
(text) |
||
REPLACE |
Replaces part of a text string, based on the number of characters that you specify, with a different text string |
(old_text,start_num,
num_chars,new_text) |
||
REPLACEB |
Replaces part of a text string, based on the number of bytes that you specify, with a different text string |
(old_text,start_num,
num_chars,new_text) |
||
REPT |
Repeats text a given number of times |
(text,number_times) |
||
RIGHT |
Returns the rightmost characters from a text value based on a number of characters that
you specify |
(text,numb_chars) |
||
RIGHTB |
Returns the rightmost characters from a text value based on a number of bytes that you specify |
(text,numb_bytes) |
||
SEARCH, SEARCHB |
Finds one text value within
another (not case-sensitive) |
(find_text,within_text,
start_num) |
||
SUBSTITUTE |
Substitutes new text for old text in a text string |
(text,old_text,new_text,
instance_num) |
||
T |
Converts its arguments to text |
(value) |
||
TEXT |
Formats a number and converts it to text |
(value,format_text) |
||
TRIM |
Removes spaces from text |
(text) |
||
UPPER |
Converts text to uppercase |
(text) |
||
VALUE |
Converts a text argument to
a number |
(text) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
