| FORMATTING |
| CLEAN |
Clean non-printable characters text |
| CONCAT |
Concatenate two text strings with an optional joiner |
| CRLF |
Returns the ascii carriage return-line feed |
| DEC2FRAC |
Returns a text representation of a decimal converted to a fraction |
| DOLLAR |
Converts a number to text with a currency format |
| FIXED |
Formats a number as text with a fixed number of decimals |
| FORMATDATE |
Formats a date according to Microsoft DOTNET formatting standards |
| FORMATNUM |
Formats a number according to Microsoft DOTNET formatting standards |
| FRAC2DEC |
Inverse of DEC2FRAC, converts a text representation of a fraction to a decimal number |
| INDENT |
Indents a text string (incl. multi-line) to a specified number of levels with a specified indentation character |
| JOINSTR |
Returns the concatenation of columnar data from a table or view |
| JOINSTR_q |
Returns the concatenation of columnar data from a query |
| PADLEFT |
Pads text to a specified width using a padding cahracter to the left of the original text |
| PADRIGHT |
Pads text to a specified width using a padding cahracter to the right of the original text |
| PARSE |
Returns the requested instance of an item delimited by one or more separators |
| PCT2FRAC |
Converts a given percentage value to a text representation of a fraction. |
| PROPER |
Capitalizes the first letter of each word in a text string |
| QUOTED |
Returns text surrounded with a double quote character |
| QUOTES |
Returns text surrounded with a single quote character |
| SPLIT |
Splits a string into one or more rows by a single or multi-character delimeter |
| STRIP |
Strips all punctuation from the beginning and end of a text string |
| SUBSTITUTE |
Replaces specified instances of text in a text string |
| TEXT |
Formats a number according to excel format styles |
| TRIM |
Trims leading and trailing spaces from a text string |
| VALUE |
Converts text to a number (float) |
| |
|
| INSPECTION |
| CONTAINSSTR |
Returns whether a text string contains another text string |
| COUNTSTRING |
Returns the number of occurences of one string within another |
| ENDSWITH |
Returns whether a text string ends with another text string |
| EXACT |
Returns whether two strings are equal |
| FIND |
Finds one text value within another |
| INSTR |
Returns the first character position of one text string within another |
| INSTRREV |
Returns the character position of the last instance of one text string within another |
| ISALPHA |
Returns whether a text string contains only alphabetic characters |
| ISNUMERIC |
Returns whether a text string represents a number |
| NUMWORDS |
Returns the number of items delimeted by one or more separators |
| STARTSWITH |
Returns whether a text string starts with another text string |
| |
|
| CALENDAR |
| NETWORKDAYS |
Returns the number of working days (non weekend or holiday) between two dates |
| NETWORKDAYS_q |
Returns the number of working days (non weekend or holiday) between two dates |
| WORKDAY |
Calculates a work day (non weekend or holiday) from a start date and offset |
| WORKDAY_q |
Calculates a work day (non weekend or holiday) from a start date and offset |
| |
|
| LOGIC |
| IIFSTR |
Returns one of two strings depending on a boolean condition |
| |
|
| |
|
| VERSION INFORMATION / MISC |
| XLDB_STRINGS_VERSION |
Function Version Information |
| |
|
| Gettysburg Address |
Sample data |