Excel Formulas

Showing page 3 of 21
LOWER
Text

Converts text to lowercase

ASC
Text

Changes full-width (double-byte) characters to half-width (single-byte) characters

DBCS
Text

Changes half-width (single-byte) characters to full-width (double-byte) characters

PHONETIC
Text

Extracts the phonetic (furigana) characters from a text string

BAHTTEXT
Text

Converts a number to Thai text and adds a suffix of 'Baht'

JIS
Text

Changes half-width (single-byte) characters within a string to full-width (double-byte) characters

CHAR
Text

Returns the character specified by a number

CODE
Text

Returns a numeric code for the first character in a text string

CONCAT
Text

Combines the text from multiple ranges and/or strings

TEXTJOIN
Text

Combines the text from multiple ranges with a delimiter

HYPERLINK
Text

Creates a hyperlink to a document

INFO
Information

Returns information about the current operating environment

CELL
Information

Returns information about the formatting, location, or contents of a cell

NA
Information

Returns the error value #N/A

ERROR.TYPE
Information

Returns a number corresponding to an error type

ISBLANK
Information

Returns TRUE if the value is blank

ISERR
Information

Returns TRUE if the value is any error value except #N/A

ISERROR
Information

Returns TRUE if the value is any error value

ISEVEN
Information

Returns TRUE if the number is even

ISFORMULA
Information

Returns TRUE if there is a reference to a cell that contains a formula

Page 3 of 21