Archive

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Returns a string of characters from the middle of a text string, given a starting position and length.

Converts all letters in a text string to lowercase.

Returns the number of characters in a text string.

Returns the specified number of characters from the start of a text string.

Converts a value to text according to the specified format.

Rounds a number to the specified number of decimals and returns the result as text. You can specify that the result be returned with or without commas.

Returns the starting position of one text string within another text string. FIND is case-sensitive.

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. You can use EXACT to test text being entered into a document.