• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Text Functions

Text Functions

CHAR(number) Returns the character specified by the code number.
CLEAN(text) Removes all nonprintable characters from text.
CODE(text) Returns a numeric code for the first character in a text string.
CONCATENATE(text1,text2,…) Joins several text items into one text item.
DOLLAR(number,decimals) Converts a number to text, using currency format.
EXACT(text1,text2) Checks to see if two text values are identical.
FIND(find_text,within_text,start_num) Finds one text value within another. This function is case-sensitive.
FIXED(number,decimals,no_commas) Formats a number as text with a fixed number of decimals.
LEFT(text,num_chars) Returns the leftmost characters from a text value.
LEN(text) Returns the number of characters in a text string.
LOWER(text) Converts text to lowercase.
MID(text,start_num,num_chars) Returns a specific number of characters from a text string.
PROPER(text) Capitalizes the first letter in each word of a text value.
REPLACE(old_text,start_num,num_chars,new_text) Replaces characters within text.
REPT(text,number_times) Repeats text a given number of times.
RIGHT(text,num_chars) Returns the rightmost characters from a text value.
SEARCH(find_text,within_text,start_num) Finds one text value within another. This function is not case-sensitive.
SUBSTITUTE(text,old_text,new_text,instance_num) Substitutes new text for old text in a text string.
T(value) Converts its arguments to text.
TEXT(value,format_text) Formats a number and converts it to text.
TRIM(text) Removes spaces from text.
UPPER(text) Converts text to uppercase.
VALUE(text) Converts a text argument to a number.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint