Turn Text into
Excel Formulas

Searches for a value in the first column of a table array and returns a value in the same row from another column.

A modern replacement for VLOOKUP, HLOOKUP, and LOOKUP. Searches a range or an array, and returns an item corresponding to the first match it finds.

Checks whether a condition is met, and returns one value if true, and another value if false.

Adds all the numbers in a range of cells.

Counts the number of cells within a range that meet a single criterion.

Adds the cells specified by a given condition or criteria.

Returns the value of an element in a table or an array, selected by the row and column number indexes.

Searches for a specified item in a range of cells, and then returns the relative position of that item in the range.

Joins two or more text strings into one string. (Note: Replaced by CONCAT and TEXTJOIN in newer versions).

Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.

Returns the first character or characters in a text string, based on the number of characters you specify.

Returns the last character or characters in a text string, based on the number of characters you specify.