Excel Formulas

Showing page 12 of 21
UNICODE
Text

Returns the number (code point) corresponding to the first character of the text

UNICHAR
Text

Returns the Unicode character specified by a given number

EXACT
Text

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise

FIND
Text

Finds one text string within another (case-sensitive)

SEARCH
Text

Finds one text string within another (not case-sensitive)

SUBSTITUTE
Text

Substitutes new text for old text in a text string

REPLACE
Text

Replaces part of a text string with a different text string

REPT
Text

Repeats text a given number of times

FIXED
Text

Formats a number as text with a fixed number of decimals

DOLLAR
Text

Converts a number to text, using currency format

LOWER
Text

Converts all uppercase letters in a text string to lowercase

UPPER
Text

Converts text to uppercase

VALUE
Text

Converts a text string that represents a number to a number

TEXT
Text

Formats a number and converts it to text

LEN
Text

Returns the number of characters in a text string

RAND
Math

Returns a random number between 0 and 1

RANDBETWEEN
Math

Returns a random integer number between the numbers you specify

PI
Math

Returns the value of pi

DEGREES
Math

Converts radians to degrees

RADIANS
Math

Converts degrees to radians

Page 12 of 21