Microsoft Excel has recently introduced three powerful new functions that leverage regular expressions (REGEX) to enhance text manipulation capabilities.

For instance, Excel functions can convert text to upper and lower case, but there's no Excel function for converting text to sentence case.

Excel can be a time sink. If you are tired of wrestling with VLOOKUPs, filtering data, and text manipulation, it’s time to adopt these key Excel functions and shortcuts. From complex data ...

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.